public UpgradeSchema ( |
||
scripts | ||
return | bool |
static void Main(string[] args) { using (var driver = new Codaxy.Common.SqlServer.SqlSchemaUpgradeManager { BackupLocation = ".", ConnectionString = "Server=.;Database=UpgradeTesting;Integrated Security=True", GetVersionSqlCommandText = "SELECT [Current] FROM dbo.[Version]", SetVersionSqlCommandText = "UPDATE dbo.[Version] SET [Current]='{Version}'", UpgradeBackupAndRestoreOnError = true, IgnoreScriptFailures = true, Logger = new Logger(new ConsoleLogAppender()) }) { driver.UpgradeSchema(new SqlScript[] { new SqlScript { SQL = "SELECT 1", Name = "1000.sql" }, new SqlScript { SQL = "ERROR", Name = "1001.sql" }, new SqlScript { SQL = "SELECT 2", Name = "1002.sql" } }); } }
static void Main(string[] args) { using (var driver = new Codaxy.Common.SqlServer.SqlSchemaUpgradeManager { BackupLocation = ".", ConnectionString = "Server=.;Database=UpgradeTesting;Integrated Security=True", GetVersionSqlCommandText = "SELECT [Current] FROM dbo.[Version]", SetVersionSqlCommandText = "UPDATE dbo.[Version] SET [Current]='{Version}'", UpgradeBackupAndRestoreOnError = true, IgnoreScriptFailures = true, Logger = new Logger(new ConsoleLogAppender()) }) { driver.UpgradeSchema(new SqlScript[] { new SqlScript { SQL = "SELECT 1", Name = "1000.sql" }, new SqlScript { SQL = "ERROR", Name = "1001.sql" }, new SqlScript { SQL = "SELECT 2", Name = "1002.sql" } }); } }