在SQL Server和SQL Express之间同步

本文介绍了在SQL Server和SQL Express之间同步的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

提前致谢

Jitendra

解决方案

这里是一个快速比较合并复制和同步框架： http： //blogs.msdn/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 code.msdn.microsoft/Release/ProjectReleases.aspx?ProjectName=sync&ReleaseId=3762for 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: blogs.msdn/sqlservercompact/archive/2009/11/09/merge-replication-vs-sync-services-for-compact.aspx