public static void Run(string connectionString)
{
var firstMigration = typeof(Lucid.Database.Migrations.Y2016.M01.V01);
var assembly = new SingleAssembly(firstMigration.Assembly);
var migrationGenerator = new SqlServer2008Generator();
var announcer = new NullAnnouncer();
var options = new ProcessorOptions();
var dbFactory = new SqlServerDbFactory();
var runnerContext = new RunnerContext(announcer)
{
Database = "SqlServer2008",
Connection = connectionString,
Targets = new string[] { firstMigration.Assembly.FullName },
NestedNamespaces = true,
Namespace = "Lucid.Database.Migrations",
};
using (var connection = new SqlConnection(connectionString))
using (var processor = new SqlServerProcessor(connection, migrationGenerator, announcer, options, dbFactory))
{
var runner = new MigrationRunner(assembly, runnerContext, processor);
runner.MigrateUp();
}
}
protected override void ApplicationStartup(TinyIoCContainer container, IPipelines pipelines)
{
base.ApplicationStartup(container, pipelines);
var announcer = new NullAnnouncer();
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
Namespace = "Server.Migrations"
};
var options = new MigrationOptions();
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2008ProcessorFactory();
var processor = factory.Create(
ConfigurationManager.ConnectionStrings["Simple.Data.Properties.Settings.DefaultConnectionString"].ConnectionString,
announcer,
options);
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
pipelines.EnableBasicAuthentication(new BasicAuthenticationConfiguration(new UserValidator(), "CPNRealm"));
JsonSettings.RetainCasing = true;
StaticConfiguration.DisableErrorTraces = false;
}
/// <summary>
/// Migration runner
/// </summary>
/// <param name="connectionString">Database connection string</param>
/// <param name="assembly">Assembly containing the migration classes to run</param>
public Runner(string connectionString, Assembly assembly)
{
_connectionString = connectionString;
_assembly = assembly;
Announcer = new NullAnnouncer();
Options = new ProcessorOptions();
MigrationGenerator = new SqlServer2008Generator();
}
private static MigrationRunner GetRunner(string connectionString, IMigrationProcessorFactory factory)
{
var announcer = new NullAnnouncer();
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer) { Namespace = "Migrations" };
var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 };
var processor = factory.Create(connectionString, announcer, options);
return new MigrationRunner(assembly, migrationContext, processor);
}
private void MigrateTo(long targetVersion)
{
var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 };
var announcer = new NullAnnouncer();
var processor = new SqlServer2012ProcessorFactory().Create(connectionString, announcer, options);
var migrationContext = new RunnerContext(announcer) { Namespace = "DDDEastAnglia.DatabaseMigrations.Migrations" };
var runner = new MigrationRunner(GetType().Assembly, migrationContext, processor);
runner.MigrateUp(targetVersion, true);
}
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 void Run()
{
var announcer = new NullAnnouncer();
var assembly = Assembly.GetExecutingAssembly();
var migrationContext = new RunnerContext(announcer)
{
Namespace = typeof(FluentDbMigrator).Namespace + ".Migrations"
};
var factory = GetProcessorFactory(_configuration.DbProvider);
var processor = factory.Create(_configuration.ConnectionString, announcer,
new ProcessorOptions { PreviewOnly = false, Timeout = 60 });
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
/// <summary>
/// Migrate the database to the latest version.
/// </summary>
/// <param name="connectionStringName">The name of the connection string.</param>
public static void MigrateToLatest(string connectionStringName)
{
var announcer = new NullAnnouncer();
var assembly = Assembly.GetAssembly(typeof(CreateCountriesTable));
var migrationContext = new RunnerContext(announcer)
{
Namespace = "ExampleApplication.Database.Migrations"
};
var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 };
var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2014ProcessorFactory();
using (var processor = factory.Create(connectionStringName, announcer, options))
{
var runner = new MigrationRunner(assembly, migrationContext, processor);
runner.MigrateUp(true);
}
}
public static void MigrateDown(string connectionString, long version, Stream stream, bool previewOnly)
{
if (version == 0)
{
Console.WriteLine(string.Format("Purging Database"));
Honcho.Migrations.DatabasePurge.Migrate.Execute(connectionString);
Console.WriteLine(string.Format("Database Purge Complete"));
}
else
{
Console.WriteLine(string.Format("Executing Migration Rollback Scripts."));
using (var connection = new SqlConnection(connectionString))
{
IAnnouncer announcer = new NullAnnouncer(); // TextWriterAnnouncer(Console.Out);
var processorOptions = new ProcessorOptions
{
PreviewOnly = previewOnly
};
if (stream != null)
{
announcer = new TextWriterAnnouncer(new StreamWriter(stream));
}
var runnerContext = new RunnerContext(announcer);
var processor = new SqlServerProcessor(connection, new SqlServer2008Generator(), announcer,
processorOptions);
var runner = new MigrationRunner(Assembly.GetAssembly(typeof (Runner)), runnerContext,
processor);
runner.RollbackToVersion(version);
}
Console.WriteLine(string.Format("Migration Rollback Script Execution Complete"));
}
}
private static IEnumerable<MigrationRunner> CreateMigrator(Assembly migrationAssembly, IEnumerable<string> connectionStrings)
{
var nullAnnouncer = new NullAnnouncer();
foreach (
var connectionString in connectionStrings.Where(connectionString => ConfigurationManager.ConnectionStrings[connectionString] != null))
{
if (string.IsNullOrEmpty(connectionString))
throw new Exception(
string.Format("Could not find a valid connection string to run the migrations against"));
var factory = new SqlServer2008ProcessorFactory();
var processor =
factory.Create(ConfigurationManager.ConnectionStrings[connectionString].ConnectionString,
nullAnnouncer,
new ProcessorOptions());
var context = new RunnerContext(nullAnnouncer);
var runner = new MigrationRunner(migrationAssembly, context, processor);
Console.WriteLine(string.Format("Creating migration using {0}", connectionString));
yield return runner;
}
}
private static IEnumerable<MigrationRunner> CreateProfileRunner(Assembly migrationAssembly)
{
var nullAnnouncer = new NullAnnouncer();
var potentialConnectionStrings = new[] {"iBrokerConnectionString", "iCimsConnectionString"};
foreach (
var connectionString in
potentialConnectionStrings.Where(connectionString => ConfigurationManager.ConnectionStrings[connectionString] != null))
{
if (string.IsNullOrEmpty(connectionString))
throw new Exception(
string.Format("Could not find a valid connection string to run the migrations against"));
var factory = new SqlServer2008ProcessorFactory();
var processor =
factory.Create(ConfigurationManager.ConnectionStrings[connectionString].ConnectionString,
nullAnnouncer,
new ProcessorOptions());
var context = new RunnerContext(nullAnnouncer)
{
Profile = "Development"
};
var runner = new MigrationRunner(migrationAssembly, context, processor);
yield return runner;
}
}
private MigrationRunner MigrationRunner()
{
IAnnouncer announcer = new NullAnnouncer();
IRunnerContext context = new RunnerContext(announcer);
IMigrationProcessorFactory processorFactory = new SqlServer2008ProcessorFactory();
IMigrationProcessorOptions options = new ProcessorOptions { PreviewOnly = false, Timeout = 0 };
IMigrationProcessor processor = processorFactory.Create(DatabaseConnectionString, announcer, options);
return new MigrationRunner(Assembly.GetExecutingAssembly(), context, processor);
}
public static void MigrateUp(string connectionString, long? version, Stream stream, bool previewOnly)
{
if (Migrate.Exists(connectionString))
{
Console.WriteLine(string.Format("AspNet Membership Exists. No Action Needed."));
}
else
{
Console.WriteLine(string.Format("Installing AspNet Membership"));
Migrate.InstallIfDoesNotExist(connectionString);
Console.WriteLine(string.Format("AspNet Membership Install Complete"));
}
Console.WriteLine(string.Format("Executing Migration Scripts."));
using (var connection = new SqlConnection(connectionString))
{
IAnnouncer announcer = new NullAnnouncer(); // TextWriterAnnouncer(Console.Out);
var processorOptions = new ProcessorOptions
{
PreviewOnly = previewOnly
};
if (stream != null)
{
announcer = new TextWriterAnnouncer(new StreamWriter(stream));
}
var runnerContext = new RunnerContext(announcer);
var processor = new SqlServerProcessor(connection, new SqlServer2008Generator(), announcer, processorOptions);
var runner = new MigrationRunner(Assembly.GetAssembly(typeof(Runner)), runnerContext, processor);
if (version.HasValue)
runner.MigrateUp(version.Value);
else
runner.MigrateUp();
}
Console.WriteLine(string.Format("Migration Script Execution Complete"));
}
