private void GenerateForTables(SysDatabase sourceDb, SysDatabase targetDb) { var script = new DbTableScriptGenerator().GenerateSingleObjectSyncScript(sourceDb, targetDb); if (!String.IsNullOrEmpty(script)) { script = String.Format("USE [{0}]{1}{1}{2}", targetDb.Name, Environment.NewLine, script); System.IO.File.WriteAllText(String.Format(@"{0}\{1}_{2}.sql", _directory, "TableScript", _dateStamp), script); } }
public override String Process(SysDatabase source, SysDatabase target) { try { var generator = new DbTableScriptGenerator(); { var script = generator.GenerateSingleObjectSyncScript(source, target); if (!String.IsNullOrEmpty(script)) { script = String.Format("USE [{0}]{1}{1}{2}", target.Name, Environment.NewLine, script); GenerateFile(script); } } return Resources.OperationMessages.TableSyncSuccess; } catch (Exception ex) { Error = true; return ex.Message; } }