public static void RunMigrations(string connectionString, string migration)
{
// var announcer = new NullAnnouncer();
var announcer = new TextWriterAnnouncer(s => System.Diagnostics.Debug.WriteLine(s));
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
Namespace = "Azimuth.Migrations",
WorkingDirectory = "Migrations"
};
var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 };
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
var processor = factory.Create(connectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
switch (migration)
{
case "Run migrations":
runner.MigrateUp(true);
break;
case "Drop all tables":
runner.RollbackToVersion(201408091845);
runner.Rollback(1);
break;
}
}
private static void Migrate(string connectionString)
{
var announcer = new TextWriterAnnouncer(Console.Out);
var migrationContext = new RunnerContext(announcer);
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
var assembly = typeof(MigrationProgram).Assembly;
using (var processor = factory.Create(connectionString, announcer, new ProcessorOptions()))
{
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp();
}
}
public void MigrateToLatest()
{
var announcer = new TextWriterAnnouncer(s => Debug.WriteLine(s));
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer);
var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 };
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
using (var processor = factory.Create(connectionString, announcer, options))
{
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
}
private IMigrationProcessor MakeProcessor(TextWriterAnnouncer announcer, MigrationOptions options)
{
if (connectionInfo.ProviderName == Constants.SqlCeProvider)
{
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServerCeProcessorFactory();
var processor = factory.Create(connectionInfo.ConnectionString, announcer, options);
return(processor);
}
else
{
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
var processor = factory.Create(connectionInfo.ConnectionString, announcer, options);
return(processor);
}
}
public static void MigrateToLatest(string connectionString)
{
var announcer = new NullAnnouncer();
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
Namespace = "Hinata.Data.Migrations"
};
var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 };
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
var processor = factory.Create(connectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
public static void MigrateToLatest(string connectionString)
{
// var announcer = new NullAnnouncer();
var announcer = new TextWriterAnnouncer(s => System.Diagnostics.Debug.WriteLine(s));
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
Namespace = "Zoo.Models.Migrations"
};
var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 };
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
var processor = factory.Create(connectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
public void MigrateDown(long targetVersion)
{
var announcer = new TextWriterAnnouncer(s => Debug.WriteLine(s));
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer);
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
using (var processor = factory.Create(connectionString, announcer, options))
{
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateDown(targetVersion, true);
}
}
public static void ApplyMigration(Assembly assembly, ConnectionStringSettings connectionString)
{
var announcer = new TextWriterAnnouncer(s => Debug.WriteLine(s));
var migrationContext = new RunnerContext(announcer)
{
Profile = "Default"
};
var options = new ProcessorOptions {
PreviewOnly = false, Timeout = 60
};
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
var processor = factory.Create(connectionString.ConnectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
public static void MigrateToLatest(string connectionString)
{
var announcer = new NullAnnouncer();
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
Namespace = "Bloqs.Logging.Data.Migrations"
};
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
var processor = factory.Create(connectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
public void Migrate(Assembly assembly, Action <IMigrationRunner> runnerAction)
{
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 0
};
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
var announcer = GetAnnouncer();
var migrationContext = new RunnerContext(announcer)
{
Profile = "IntegrationTests",
ApplicationContext = "BaselineSetup"
};
var processor = factory.Create(this.connectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runnerAction(runner);
}
public static void MigrateDownOne(string connectionString)
{
var announcer = new TextWriterAnnouncer(s => System.Diagnostics.Debug.WriteLine(s));
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
Namespace = "Parakeet.Data.Migrator"
};
var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 };
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
using (var processor = factory.Create(connectionString, announcer, options))
{
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.VersionLoader.LoadVersionInfo();
runner.ListMigrations();
runner.MigrateDown(runner.VersionLoader.VersionInfo.Latest() - 1);
}
}
public static void MigrateToLatest(string connectionString)
{
// var announcer = new NullAnnouncer();
var announcer = new TextWriterAnnouncer(s => System.Diagnostics.Debug.WriteLine(s));
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
Namespace = "Zoo.Models.Migrations"
};
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
var processor = factory.Create(connectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
private static void MigrateASDBToLates(string connectionString, Assembly asm)
{
//put log for net later
TextWriterAnnouncer announcer = new TextWriterAnnouncer(s => System.Diagnostics.Debug.WriteLine(s));
RunnerContext migrationContext = new RunnerContext(announcer)
{
Tags = MigrationTags.MigTagList
};
MigrationOptions options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory factory =
new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
using (var processor = factory.Create(connectionString, announcer, options))
{
MigrationRunner runner = new MigrationRunner(asm, migrationContext, processor);
runner.MigrateUp();
}
}
public static void MigrateToLatest(string connectionString)
{
if (!IsConnectionStringValid(connectionString))
{
return;
}
var announcer = new TextWriterAnnouncer(Console.WriteLine);
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
Connection = connectionString,
TransactionPerSession = true
};
var options = new MigrationOptions {
PreviewOnly = false, Timeout = 60
};
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
var processor = factory.Create(connectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(false);
}
public static void ApplyMigration(Assembly assembly, ConnectionStringSettings connectionString)
{
var announcer = new TextWriterAnnouncer(s => Debug.WriteLine(s));
var migrationContext = new RunnerContext(announcer)
{
Profile = "Default"
};
var options = new ProcessorOptions { PreviewOnly = false, Timeout = 60 };
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2012ProcessorFactory();
var processor = factory.Create(connectionString.ConnectionString, announcer, options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
