public void ShouldScriptAllTables() { IList <DbObjectName> tables = engine.GetAllTables(connectionSettings); scriptingOptions.AddTablesToScript(tables); engine.Script(connectionSettings, scriptingOptions); }
//[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 void ShouldScriptAllTableFKs() { IList <DbObjectName> tables = engine.GetAllTables(connSettings); ScriptingOptions options = new ScriptingOptions(); options.ExportDirectory = exportDir; options.ScriptForeignKeys = true; options.AddTablesToScript(tables); engine.Script(connSettings, options); string dataPath = Path.Combine(exportDir, "Schema\\ForeignKeys"); Assert.IsTrue(File.Exists(Path.Combine(dataPath, "dbo.Address.sql")), "address script missing"); }
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 void ShouldScriptAllTableIndexes() { IList <DbObjectName> tables = engine.GetAllTables(connSettings); ScriptingOptions options = new ScriptingOptions(); options.ExportDirectory = exportDir; options.ScriptIndexes = true; options.AddTablesToScript(tables); engine.Script(connSettings, options); string dataPath = Path.Combine(exportDir, "Schema\\Indexes"); 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 ShouldScriptEverythingToSingleScript() { IList <DbObjectName> views = engine.GetAllViews(connSettings); IList <DbObjectName> sprocs = engine.GetAllSprocs(connSettings); IList <DbObjectName> tables = engine.GetAllTables(connSettings); ScriptingOptions options = new ScriptingOptions(); options.ExportDirectory = exportDir; options.AddTablesToScript(tables); options.AddSprocsToScript(sprocs); options.AddViewsToScript(views); options.ScriptData = true; options.ScriptForeignKeys = true; options.ScriptIndexes = true; options.ScriptSchema = true; options.UseMultipleFiles = false; engine.Script(connSettings, options); Assert.IsTrue(File.Exists(Path.Combine(exportDir, "SqlMigration1.sql"))); }