在SQL Server和SQL Express之间同步 [英] Sync between SQL Server and SQL Express

问题描述

我们正在尝试使用Sync Framework 2.0创建偶尔连接的应用程序。服务器将使用SQL Server 2005和客户端SQL 2005 Express。我们已经实现了中使用的代码 http://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=同步& ReleaseId = 3762    用于2个SQL Server数据库之间的同步。但是当我阅读不同的博客时，它说Sync Framework不支持架构更改，为此我们应该使用合并复制。在我们的senario中，我们必须使用服务器数据库复制300个SQL Express客户端数据库，该数据库是具有SQL Server 2005的网站。我们还希望远程复制的速度是什么，以避免将来出现问题的最佳技术？

 

提前致谢

 

Jitendra

解决方案

这里是一个快速比较合并复制和同步框架： http： //blogs.msdn.com/sqlservercompact/archive/2009/11/09/merge-replication-vs-sync-services-for-compact.aspx

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

解决方案

here's a quick comparison between merge replication and sync framework: http://blogs.msdn.com/sqlservercompact/archive/2009/11/09/merge-replication-vs-sync-services-for-compact.aspx

这篇关于在SQL Server和SQL Express之间同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！