开发者

synchronize sql server 2000 with sql server 2008

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜