How to get updated records in remote SQL Server and update them in my local server?
I have a local SQL Server and开发者_Python百科 a remote SQL Server. I want to when user updates records in remote SQL Server the equivalent records be updated in my local SQL Server.
How can I get updated records in remote SQL Server?
Just care about it, I can't add trigger or a datetime
field to remote SQL Server.
Are there any useful information in sys tables for updated records?
The built-in mechanism(s) to do this is Server Replication, your often better off doing this than rolling out your own solution.
精彩评论