I am trying to configure an N-tier sync, but have encountered the following fault:
Cannot find a valid scope with the name 'MyScope' in table '[scope_info]'. Ensure that this scope exists and that it has a corresponding valid configuration in the configuration table '[scope_config]'.
Here are the methods I am using in the web service to provision my database for sync. Am I missing something?
protected override RelationalSyncProvider ConfigureProvider(string scopeName, string connectionString)
{
Connection = new SqlConnection(connectionString);
Connection.Open();
SqlSyncProvider provider = new SqlSyncProvider(scopeName, Connection);
//create anew scope description and add the appropriate tables to this scope
DbSyncScopeDescription scopeDescription = new DbSyncScopeDescription(scopeName);
PopulateScopeDescription(scopeDescription);
//class to be used to provision the scope defined above
SqlSyncScopeProvisioning scopeProvision = new SqlSyncScopeProvisioning(Connection, scopeDescription, SqlSyncScopeProvisioningType.Template);
scopeProvision.ObjectSchema = "sync";
//determine if this scope already exists on the server and if not go ahead and provision
if (!scopeProvision.ScopeExists(scopeName))
{
//add the approrpiate tables to this scope
ConfigureScopeProvision(scopeProvision);
//note that it is important to call this after the tables have been added to the scope
scopeProvision.PopulateFromScopeDescription(scopeDescription);
//indicate that the base table already exists and does not need to be created
scopeProvision.SetCreateTableDefault(DbSyncCreationOption.Skip);
scopeProvision.SetCreateTrackingTableDefault(DbSyncCreationOption.CreateOrUseExisting);
//provision the server
scopeProvision.Apply();
}
return provider;
}
protected override void ConfigureScopeProvision(SqlSyncScopeProvisioning scopeProvision)
{
foreach (string table in TableNames.ProjectFiltered)
{
SqlSyncTableProvisioning tableProvision = scopeProvision.Tables[table];
tableProvision.AddFilterColumn("ProjectID");
tableProvision.FilterClause = string.Format("(@ProjectID = -1 OR ([{0}].[ProjectID] = @ProjectID OR [{0}].[ProjectID] IN (SELECT DISTINCT [ProjectID] FROM [DataSets] WHERE [IsPublished] = 1)))", table);
tableProvision.FilterParameters.Add(new SqlParameter("@ProjectID", SqlDbType.Int));
}
foreach (var entry in TableNames.DataSetFiltered)
{
string column = entry.Key;
foreach (string table in entry.Value)
{
SqlSyncTableProvisioning tableProvision = scopeProvision.Tables[table];
tableProvision.AddFilterColumn(column);
tableProvision.FilterClause = string.Format("([{0}].[{1}] IN (SELECT [DataSets].[DataSetGUID] FROM [DataSets] WHERE (IsActive = 1) AND ([DataSets].[ProjectID] = @ProjectID OR IsPublished = 1)))", table, column);
tableProvision.FilterParameters.Add(new SqlParameter("@ProjectID", SqlDbType.Int));
}
}
}
protected override void PopulateScopeDescription(DbSyncScopeDescription scopeDescription)
{
foreach (string table in TableNames.Names)
{
scopeDescription.Tables.Add(SqlSyncDescriptionBuilder.GetDescriptionForTable(table, Connection));
}
}
