Need to duplicate changes from Server A - Table A to Server B - Table B
Posted on 2011-09-20
We have a web application which makes changes to a database table. Lets call it Server A - Table A. I would then like to, on the database end, mirror those changes to an identical table that lives on a different server. Lets call it Server B - Table B.
So if a new row of data is added to Server A - Table A, I'd like Server B - Table B to be updated with the same changes. Same if a row is updated in Server A - Table A. A row will never be deleted so no need to worry about that.
What's the best way to do this? Any help would be appreciated.