public void ShouldScriptCustomerDataDifferences()
{
IList <DbObjectName> tables = engine.GetAllTables(connSettings1);
ScriptingOptions options = new ScriptingOptions();
options.ExportDirectory = exportDir;
options.ScriptData = true;
options.AddTablesToScript(tables);
engine.ScriptDifferences(connSettings1, connSettings2, options);
string dataPath = Path.Combine(exportDir, "\\Data");
Assert.IsTrue(File.Exists(Path.Combine(dataPath, "dbo.Customer.sql")));
Assert.IsTrue(File.Exists(Path.Combine(dataPath, "dbo.Address.sql")));
Assert.IsTrue(File.Exists(Path.Combine(dataPath, "dbo.SoftwareVersion.sql")));
}
public int Run(CmdLineScriptingOptions scriptingOptions, IConnectionSettings srcConnSettings,
IConnectionSettings targetConnSettings)
{
MigrationEngine engine = new MigrationEngine(new SqlServerScriptBuilder());
engine.MessageManager = messageMgr;
if (string.IsNullOrEmpty(targetConnSettings.Database) && scriptingOptions.ExecutorScripts.Count == 0)
{
engine.Script(srcConnSettings, scriptingOptions);
}
else if (scriptingOptions.ExecutorScripts.Count > 0)
{
engine.Execute(srcConnSettings, scriptingOptions.ExecutorScripts);
}
else if (!string.IsNullOrEmpty(targetConnSettings.Database))
{
engine.ScriptDifferences(srcConnSettings, targetConnSettings, scriptingOptions);
}
return(0);
}
public void ShouldThrowIfConnectionSettings1IsNull_ScriptDifferences()
{
engine.ScriptDifferences(null, connSettings, new ScriptingOptions());
}
