This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Sync Framework for different versions of SQL server

Question
0

Sign in to vote
Hi,
Is it possible to synchronize SQL 2000 and SQL 2008 using sync framework?
If yes are there any examples in the web?

Phaneendra.
- Moved by Liam Cavanagh - MSFTMicrosoft employee Thursday, January 21, 2010 4:36 PM (From:SyncFx - General)
Wednesday, January 20, 2010 11:13 AM

Answers

0

Sign in to vote
Hi,

The Collaboration providers could work.
You could easily try it for yourself by adapting the SQL-SQL Sample:
http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3762

If there are statements that are not supported by SQL 2000, you could use the DbsyncProvider to customize the commands: see http://msdn.microsoft.com/en-us/library/cc807291(SQL.105).aspx

HTH.
- Marked as answer by Liam Cavanagh - MSFTMicrosoft employee Thursday, January 21, 2010 8:32 PM
Thursday, January 21, 2010 12:22 PM