开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜