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);
}
