Search code examples
sql-servermicrosoft-sync-framework

Using microsoft sync framework 2.1 for SQL Server 2000

We need to synchronize database and image files between two servers. The source server has sql server 2000 and the destination server has sql server 2008. We need to synchronize data in some tables in sql server 2000 so that the updated data comes to sql server 2008 every once in a while. Similarly for the folder where images are stored.

I tried to implement Microsoft sync framework (http://msdn.microsoft.com/sync) with WCF to achieve the goal. I ran the following project successfully for two databases in SQL Server 2008:

http://code.msdn.microsoft.com/Database-SyncSQL-Server-e97d1208/sourcecode?fileId=19017&pathId=519811259

However, when I tried to synchronize data between database, one in sql server 2000 and sql server 2008, then I could not synchronize data.

Questions:

  1. Is there anyway to synchronize data between sql server 2000 and sql server 2008?

  2. If not, are there any other possible architectures i can implement to achieve the objective?

Solution

  • the minimum Sql Server version for the sync provider in the sample you used above is Sql Server 2005 SP2 (where min_active_version() was introduced.)

    try using the steps in this link so you can overrride the commands and make them work against Sql 2000: Synchronizing Other ADO.NET Compatible Databases