public static void MigrateToLatest(string connectionString, string migrationAssemblyName) { var assembly = Assembly.Load(new AssemblyName(migrationAssemblyName)); var migrationContext = new RunnerContext(Announcer) { Namespace = migrationAssemblyName + ".Migrations" }; var options = new ProcessorOptions { PreviewOnly = false, Timeout = DefaultTimeout }; var factory = new SqlServer2008ProcessorFactory(); var processor = factory.Create(connectionString, Announcer, options); var runner = new MigrationRunner(assembly, migrationContext, processor); foreach (var a in runner.MigrationAssemblies.Assemblies) { RunScriptGroup(ScriptRunningGroup.PreMigrationScript, a, processor); } runner.MigrateUp(true); foreach (var a in runner.MigrationAssemblies.Assemblies) { RunScriptGroup(ScriptRunningGroup.PostMigrationScript, a, processor); } }
public void Migrate(Action <IMigrationRunner> runnerAction) { var options = new MigrationOptions { PreviewOnly = false, Timeout = 0 }; var factory = new SqlServer2008ProcessorFactory(); var announer = new TextWriterAnnouncer(s => System.Diagnostics.Debug.WriteLine(s)); var migrationContext = new RunnerContext(announer); var processor = factory.Create(this.connectionString, announer, options); var runner = new MigrationRunner(Assembly.GetExecutingAssembly(), migrationContext, processor); runnerAction(runner); }
public void Update() { IAnnouncer announcer = CreateAnnouncer(); IRunnerContext migrationContext = new RunnerContext(announcer); ProcessorOptions options = new ProcessorOptions { PreviewOnly = false, Timeout = 200 }; IMigrationProcessorFactory factory = new SqlServer2008ProcessorFactory(); Assembly migrationContainer = typeof(InitialDeployment).Assembly; using (IMigrationProcessor processor = factory.Create(connectionString, announcer, options)) { FluentMigrator.Runner.IMigrationRunner runner = new FluentMigrator.Runner.MigrationRunner(migrationContainer, migrationContext, processor); runner.MigrateUp(); } }
private static MigrationRunner CreateMigrationRunner(string connectionString) { var announcer = new TextWriterAnnouncer(s => Debug.WriteLine(s)); var assembly = Assembly.GetExecutingAssembly(); var migrationContext = new RunnerContext(announcer) { Namespace = "Migrator.Migrations" }; var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 }; var factory = new SqlServer2008ProcessorFactory(); var processor = factory.Create(connectionString, announcer, options); var runner = new MigrationRunner(assembly, migrationContext, processor); return(runner); }
public void Migrate(Action <IMigrationRunner> runnerAction) { //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 options = new MigrationOptions { PreviewOnly = false, Timeout = 0 }; var factory = new SqlServer2008ProcessorFactory(); var assembly = Assembly.GetExecutingAssembly(); var processor = factory.Create(_connectionString, announcer, options); var runner = new MigrationRunner(assembly, migrationContext, processor); runnerAction(runner); }
private static void RunMigration() { var announcer = new TextWriterAnnouncer(Console.WriteLine) { ShowSql = true }; var assembly = Assembly.GetAssembly(typeof(Program)); var migrationContext = new RunnerContext(announcer); var options = new ProcessorOptions { PreviewOnly = false, // set to true to see the SQL Timeout = 60 }; var factory = new SqlServer2008ProcessorFactory(); IMigrationProcessor processor = factory.Create(ConnectionString, announcer, options); var runner = new MigrationRunner(assembly, migrationContext, processor); runner.MigrateUp(true); // Or go back down //runner.MigrateDown(0); }