/// <summary> /// Configure the SqlSyncprovider. Note that this method assumes you have a direct conection /// to the server as this is more of a design time use case vs. runtime use case. We think /// of provisioning the server as something that occurs before an application is deployed whereas /// provisioning the client is somethng that happens during runtime (on intitial sync) after the /// application is deployed. /// /// </summary> /// <param name="hostName"></param> /// <returns></returns> public SqlSyncProvider ConfigureSqlSyncProvider(string scopeName, string hostName) { SqlSyncProvider provider = new SqlSyncProvider(); provider.ApplyChangeFailed += new EventHandler <DbApplyChangeFailedEventArgs>(Provider_ApplyingChanges); provider.ScopeName = scopeName; SqlConn conn = new SqlConn(); provider.Connection = new SqlConnection(conn.connString); MakeBackUp(); //create anew scope description and add the appropriate tables to this scope DbSyncScopeDescription scopeDesc = new DbSyncScopeDescription("CardsScope"); //class to be used to provision the scope defined above SqlSyncScopeProvisioning serverConfig = new SqlSyncScopeProvisioning((SqlConnection)provider.Connection); //determine if this scope already exists on the server and if not go ahead and provision if (!serverConfig.ScopeExists("CardsScope")) { //add the approrpiate tables to this scope scopeDesc.Tables.Add(SqlSyncDescriptionBuilder.GetDescriptionForTable("[" + conn.schema + "].[cards]", (System.Data.SqlClient.SqlConnection)provider.Connection)); //note that it is important to call this after the tables have been added to the scope serverConfig.PopulateFromScopeDescription(scopeDesc); //indicate that the base table already exists and does not need to be created serverConfig.SetCreateTableDefault(DbSyncCreationOption.Skip); //provision the server serverConfig.Apply(); } conn.close(); return(provider); }
private void MakeBackUp() { string backUpPath = ConfigurationManager.AppSettings.Get("backUpPath"); if (backUpPath == null || backUpPath == "") { backUpPath = Directory.GetCurrentDirectory() + "\\BackUp\\"; } SqlConn conn = new SqlConn(); Directory.CreateDirectory(backUpPath); string[] files = Directory.GetFiles(@backUpPath, "*.Bak"); conn.makeBackUp(backUpPath); conn.close(); }
public static void Main(String[] args) { try { SqlConn sqlConn = new SqlConn(); ServiceHost sqlHost = new ServiceHost(typeof(SqlWebSyncService)); sqlHost.Open(); Console.WriteLine("Press <ENTER> to terminate the service host"); Console.ReadLine(); sqlHost.Close(); } catch (Exception e) { Console.WriteLine("Error in opening servicehost. " + e); Console.ReadLine(); } }