开发者

synchronize sql server 2000 with sql server 2008

开发者 https://www.devze.com 2023-03-18 20:45 出处:网络
I need to synchronize sql server 2000 data (source) in one server to sql server 2008 (destination) in another server by using wcf (one direction transfer is sufficient) so that i can take occasional u

I need to synchronize sql server 2000 data (source) in one server to sql server 2008 (destination) in another server by using wcf (one direction transfer is sufficient) so that i can take occasional updates from 2000 to 2008. Any i开发者_StackOverflow社区deas?


Sounds like SqlBulkCopy is ideal for your needs if you want to do this entirely in code.

Otherwise you could set up some sql scripts to perform backups, and schedule it as required.

0

精彩评论

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