internal static void UpgradeDatabaseVersion() { string connectionString = settings.ConnectionString; string databaseMasterPassword = settings.DatabaseMasterPassword; DatabaseValidationResult dbResult = ValidateDatabaseConnection(connectionString, databaseMasterPassword); string migrationsRoot = FileLocations.SqlMigrations; if (Directory.Exists(migrationsRoot)) { var parser = new Versioning.JustVersionParser(); var list = SqlScriptRunner.ScriptRunner.ResolveScriptsFromPathAndVersion(migrationsRoot, "*.sql", true, migrationsRoot, dbResult.CurrentVersion, Versioning.Version.Max, parser); // commit the database upgrade in next version } }
private static void ShowFailedConnectionTestMessage(DatabaseValidationResult connectionResult) { string message = string.Format("Test database failed.\r\nReason:{0}", connectionResult.ErroMessage); // todo enable database versioning //if (connectionResult.IsMinimalVersion) //{ // message += "\r\n\r\nThe specified database does include a versions table.\r\n" + // "Change the name of the database and click 'Create New' to create a new database on the server, " + // "or just hit 'Create New' to deploy into this existing database."; //} MessageBox.Show(message, MESSAGE_HEADER, MessageBoxButtons.OK, MessageBoxIcon.Error); }