public void ShouldScriptCustomerDataAsXml()
{
scriptingOptions.ScriptData = false;
scriptingOptions.ScriptDataAsXml = true;
scriptingOptions.AddTableToScript("dbo.Customer");
engine.Script(connectionSettings, scriptingOptions);
string dataPath = Path.Combine(scriptingOptions.ExportDirectory, "Data");
Assert.IsTrue(File.Exists(Path.Combine(dataPath, "dbo.CustomerAndPrimaryAddress.xml")));
}
//[Test]
public void ScriptData()
{
IList <DbObjectName> tables = engine.GetAllTables(connSettings1);
ScriptingOptions options = new ScriptingOptions();
options.ExportDirectory = exportDir;
options.ScriptData = true;
options.AddTablesToScript(tables);
engine.Script(connSettings1, options);
}
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 ShouldScriptAllTables()
{
IList <DbObjectName> tables = engine.GetAllTables(connSettings);
ScriptingOptions options = new ScriptingOptions();
options.ExportDirectory = exportDir;
options.ScriptSchema = true;
options.AddTablesToScript(tables);
engine.Script(connSettings, options);
string dataPath = Path.Combine(exportDir, "Schema\\Tables");
Assert.IsTrue(File.Exists(Path.Combine(dataPath, "dbo.Customer.sql")), "customer script missing");
Assert.IsTrue(File.Exists(Path.Combine(dataPath, "dbo.Country.sql")), "country script missing");
Assert.IsTrue(File.Exists(Path.Combine(dataPath, "dbo.Address.sql")), "address script missing");
Assert.IsTrue(File.Exists(Path.Combine(dataPath, "dbo.SoftwareVersion.sql")), "software script missing");
}
public void ShouldThrowIfConnectionSettingsIsNull_Script()
{
engine.Script(null, new ScriptingOptions());
}
