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.
精彩评论