使用Sync框架进行同步 [英] using Sync framework to synchronize
问题描述
我是Sync Framework的新手。看到Microsoft Sync Framework提供的功能非常有吸引力。这是我的新应用程序要求的完美匹配。但是我有几个问题仍然不清楚。
要求：需要将本地数据库与SQL 2000同步。
1。我试用了示例应用程序。在&abcd.sync文件中，配置数据源同步，当连接到服务器时，它要求服务器连接&客户连接。服务器能够
来选择它。但对于客户端是强制性的，只能使用Sql Server紧凑版？或者我应该使用SQL 2000或SQL 2005作为客户端数据库。如果是，那么如何做到这一点。因为我无法选择SQL Server Compact版本以外的其他版本。
2。如果我在客户端中有SQL 2008，则可以将本地数据与SQL 2000 db同步。
注意：无法将现有的SQL 2000服务器迁移到sql 2005或SQL 2008所以我必须在服务器中使用SQL 2000。
请提供您的输入/建议继续。
问候
Sasi
1  Visual Studio本地数据库缓存项目项仅适用于SQL Server作为服务器，SQL Ce作为客户端。此向导还使用脱机提供程序，除了SQL Ce之外没有现成的客户端提供程序。但是有一个示例
客户端提供程序用于Sql Express。
2。 afaik，支持的最小SQL是SQL Server 2005 SP2，因为检索锚点/时间戳的方式。
Hi,
I am new to Sync Framework. It was so attractive on seeing the features provided by Microsoft Sync Framework. This is the perfect match for my new application requirements. But i have few questions which is still unclear to me.
Requirement: Need to synchronize the local db with SQL 2000.
1. I tried out sample applications. In abcd.sync file, Configure Datasource Synchronization, when connecting to server, it asks for the server connection & client connection. The server am able to choose it. But for the client is that mandatory to use only Sql Server compact edition? Or shall i use SQL 2000 or SQL 2005 as client db. If yes, then how to do this. Because am not able to choose other than SQL Server Compact edition.
2. If i have SQL 2008 in Client is that possible to synchronize the local data with SQL 2000 db.
Note: Its not possible to migrate my existing SQL 2000 server to sql 2005 or SQL 2008. So i have to live with SQL 2000 in server.
Pls provide your inputs/suggestions to proceed with.
Regards
Sasi
1. The Visual Studio Local Database Cache project item only works with SQL Server as the server and SQL Ce as the client. This wizard also uses the offline providers and there is no out-of-the-box client provider other than SQL Ce. there is a sample client provider for Sql Express though.
2. afaik, the minimum SQL supported is SQL Server 2005 SP2 because of the way the anchors/timestamps are retrieved.
这篇关于使用Sync框架进行同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
