none
Sync between SQL Server and SQL Express RRS feed

  • Question

  • We are trying to create an occasionally connected application using Sync Framework 2.0. Server is going to use SQL Server 2005 and clients SQL 2005 Express. We have implemented the code used in  http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3762  for Synchronization between 2 SQL Server databases. But as I read different blogs it says Sync Framework does not support schema changes and for that we should use merge replication. In our senario we have to replicate 300 client database of SQL Express with Server database which is website having SQL Server 2005. We also want speed for the remote replication what is the best technology to use to avoid future problems ?

     

    Thanks in advance

     

    Jitendra

    Friday, April 16, 2010 6:12 AM

All replies