I'm using Sync Framework 2.1 to synchronise between a SQL Server 2005 database and several SQL Compact SP2 (desktop) databases.
Everything works fine for a single SQL Server Compact client synching to the server. But when I try to sync 2 SQL Server Compact clients to the same server database, changes I make to the 1st client are not synchronised to the 2nd client. I know the
changes have gone to the server database because I can see them. I can't understand why this is happening.
Here's a copy of my code:
public class
DataSynching
{
private const
string SyncScopeName =
"DataSynchronisation";
SqlConnection serverConn =
null;
SqlCeConnection clientConn =
null;
public DataSynching()
{
ScopeAndProvisionSqlServer();
ScopeAndProvisionSqlCompact();
}
private void ScopeAndProvisionSqlServer()
{
serverConn = new
SqlConnection(LocalSettings.GetSetting(LocalSettings.SettingsKey.DatabaseConnectionString));
DbSyncScopeDescription scopeDesc =
new DbSyncScopeDescription(SyncScopeName);
DbSyncTableDescription tableDescAddress =
SqlSyncDescriptionBuilder.GetDescriptionForTable("Address", serverConn);
DbSyncTableDescription tableDescBranch =
SqlSyncDescriptionBuilder.GetDescriptionForTable("Branch", serverConn);
DbSyncTableDescription tableDescUser =
SqlSyncDescriptionBuilder.GetDescriptionForTable("User", serverConn);
DbSyncTableDescription tableDescItem =
SqlSyncDescriptionBuilder.GetDescriptionForTable("Item", serverConn);
DbSyncTableDescription tableDescJob =
SqlSyncDescriptionBuilder.GetDescriptionForTable("Job", serverConn);
DbSyncTableDescription tableDescSite =
SqlSyncDescriptionBuilder.GetDescriptionForTable("Site", serverConn);
scopeDesc.Tables.Add(tableDescAddress);
scopeDesc.Tables.Add(tableDescBranch);
scopeDesc.Tables.Add(tableDescUser);
scopeDesc.Tables.Add(tableDescItem);
scopeDesc.Tables.Add(tableDescJob);
scopeDesc.Tables.Add(tableDescSite);
SqlSyncScopeProvisioning serverProvision =
new SqlSyncScopeProvisioning(serverConn, scopeDesc);
serverProvision.SetCreateTableDefault(DbSyncCreationOption.Skip);
serverProvision.Tables["Item"].AddFilterColumn("customer_id");
serverProvision.Tables["Item"].FilterClause =
String.Format("[customer_id] = {0}",
Proxy.GetSQLValue(Customer.SelectedCustomer.ID));
if (!serverProvision.ScopeExists(SyncScopeName))
{
serverProvision.Apply();
}
}
private void ScopeAndProvisionSqlCompact()
{
clientConn = new
SqlCeConnection(Customer.SelectedCustomer.ConnectionString);
DbSyncScopeDescription scopeDesc =
SqlSyncDescriptionBuilder.GetDescriptionForScope(SyncScopeName, serverConn);
SqlCeSyncScopeProvisioning clientProvision =
new SqlCeSyncScopeProvisioning(clientConn, scopeDesc);
clientProvision.SetCreateTableDefault(DbSyncCreationOption.Skip);
clientProvision.Apply();
}
public SyncOperationStatistics SyncData()
{
SyncOrchestrator syncOrchestrator =
new SyncOrchestrator();
clientConn = new
SqlCeConnection(Customer.SelectedCustomer.ConnectionString);
syncOrchestrator.LocalProvider = new
SqlCeSyncProvider(SyncScopeName, clientConn);
syncOrchestrator.RemoteProvider = new
SqlSyncProvider(SyncScopeName, serverConn);
syncOrchestrator.Direction = SyncDirectionOrder.UploadAndDownload;
((SqlCeSyncProvider)syncOrchestrator.LocalProvider).ApplyChangeFailed +=
new EventHandler<DbApplyChangeFailedEventArgs>(DataSync_LocalApplyChangeFailed);
((SqlSyncProvider)syncOrchestrator.RemoteProvider).ApplyChangeFailed +=
new EventHandler<DbApplyChangeFailedEventArgs>(DataSync_RemoteApplyChangeFailed);
return syncOrchestrator.Synchronize();
}
void DataSync_LocalApplyChangeFailed(object sender,
DbApplyChangeFailedEventArgs e)
{
if (e.Error != null)
{
e.Error.ToString();
}
}
void DataSync_RemoteApplyChangeFailed(object sender,
DbApplyChangeFailedEventArgs e)
{
if (e.Error != null)
{
e.Error.ToString();
}
}
Can someone please help?
