Replicate and Sync between Server 2k and 2k5

Hi all.

I want to do the following:

I have a (quite big) sql server 2000 database. I'd like to replicate the whole DB onto a 2k5 server. Then disconnect that connection, to have an independent copy on the 2k5 machine. After I made some modifications on the data on that machine, I'd like to sync those databases to have the data on the sql server 2000 as well.

Is this possible in any way (tool or API available) or must I hand code it? At the moment I do this thing by exporting to *.sql files, and then importing, but the replication/sync method would be quite nice.

Yours, Dave

[590 byte] By [DavidLeder] at [2007-12-24]
# 1

For this particular scenario, your best option is to use transactional replication with queued updatable subscriptions: SQL Server 2000 as the publisher and SQL Server 2005 as the subscriber. If you can upgrade SQL Server 2000 to 2005, you can use either merge replication or peer to peer transactional replication.

LiZhang at 2007-8-31 > top of Msdn Tech,SQL Server,SQL Server Replication...

SQL Server

Site Classified