How to sync data from one database to another for a single table

(0) Share

Report

Posted on by NILANKA SEKHAR PAUL

340

I have two server. Server A and Server B. Server A contains a database from which one table(dbo.xyz) i have copied to another database of Server B . Now if i update anything on that table(dbo.xyz) of Server B that update sync with Server A table(dbo.xyz) and vise-versa. After investigating i found that linked server should be configured between Server A and Server B and write a store procedure that checks whether any update done on Server B table or Server A table at certain time interval. I need to know the SQL query or Store procedure that checks the same.

*This post is locked for comments