private static void MigrateDatabaseToLastestVersion(SqlConnectionStringBuilder csb)
{
var announcer = new ConsoleAnnouncer {
ShowSql = true
};
var options = new ProcessorOptions();
var processorFactory = new SqlServer2016ProcessorFactory();
var processor = processorFactory.Create(csb.ConnectionString, announcer, options);
var context = new RunnerContext(announcer)
{
AllowBreakingChange = true
};
var runner = new MigrationRunner(typeof(FirstMigration).Assembly, context, processor);
runner.MigrateUp();
}
private void Migrate()
{
var connectionString = ConfigFixture.Config.GetConnectionString("DefaultConnection");
var announcer = new TextWriterAnnouncer(Console.WriteLine);
announcer.ShowSql = true;
var assembly = Assembly.Load("Skrabbl.DataAccess");
var migrationContext = new RunnerContext(announcer);
var options = new ProcessorOptions
{
PreviewOnly = false,
Timeout = TimeSpan.FromMinutes(1)
};
var factory = new SqlServer2016ProcessorFactory();
using var processor = factory.Create(connectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp();
}
