public void MigrateDatabase()
{
// See http://stackoverflow.com/questions/7574417/is-it-possible-to-use-fluent-migrator-in-application-start
// var announcer = new NullAnnouncer();
var announcer = new FluentMigrator.Runner.Announcers.TextWriterAnnouncer(s => System.Diagnostics.Debug.WriteLine(s));
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new FluentMigrator.Runner.Initialization.RunnerContext(announcer)
{
Namespace = "LibLogic.Migrations",
TransactionPerSession = true
};
var options = new FluentMigrator.Runner.Processors.ProcessorOptions()
{
PreviewOnly = false, // set to true to see the SQL
Timeout = 60
};
var factory = new FluentMigrator.Runner.Processors.MySql.MySqlProcessorFactory();
var processor = factory.Create(Setup.DbFactory.ConnectionString, announcer, options);
var runner = new FluentMigrator.Runner.MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
private void Check()
{
try
{
var announcer = new TextWriterAnnouncer(WriteLog);
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer);
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var factory = new FluentMigrator.Runner.Processors.MySql.MySqlProcessorFactory();
var processor = factory.Create(_provider.ConnectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
catch (InvalidMigrationException e)
{
_logger.Error("An invalid migration exception occured; {0:l}", e.Message);
}
catch (MySqlException e)
{
_logger.Error("An exception occured while running migration manager; {0:l}", e.Message);
}
}
public void Migrate(Action <IMigrationRunner> runnerAction)
{
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 0
};
var factory = new FluentMigrator.Runner.Processors.MySql.MySqlProcessorFactory();
var assembly = Assembly.GetExecutingAssembly();
//using (var announcer = new NullAnnouncer())
var announcer = new TextWriterAnnouncer(s => System.Diagnostics.Debug.WriteLine(s));
var migrationContext = new RunnerContext(announcer)
{
#if DEBUG
// will create testdata
Profile = "development"
#endif
};
var processor = factory.Create(this.connectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runnerAction(runner);
}
private void Check()
{
try
{
var announcer = new TextWriterAnnouncer(WriteLog);
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer);
var options = new MigrationOptions {PreviewOnly = false, Timeout = 60};
var factory = new FluentMigrator.Runner.Processors.MySql.MySqlProcessorFactory();
var processor = factory.Create(_provider.ConnectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
catch (InvalidMigrationException e)
{
_logger.Error("An invalid migration exception occured; {0:l}", e.Message);
}
catch (MySqlException e)
{
_logger.Error("An exception occured while running migration manager; {0:l}", e.Message);
}
}
