private IMigrationProcessor CreateMigrationProcessor(Announcer announcer)
{
var options = new ProcessorOptions
{
PreviewOnly = false, // set to true to see the SQL
Timeout = 60,
};
EnsureConnectionAvailable(_connectionString);
var factory = new SqlServer2012ProcessorFactory();
IMigrationProcessor processor = factory.Create(_connectionString, announcer, options);
return(processor);
}
public void Load()
{
Announcer announcer = new TextWriterAnnouncer(x => Debug.WriteLine(""));
var assembly = Assembly.GetExecutingAssembly();
IRunnerContext ctx = new RunnerContext(announcer);
var options = new ProcessorOptions
{
PreviewOnly = false,
Timeout = 40
};
var factory = new SqlServer2012ProcessorFactory();
string con = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString();
var processer = factory.Create(con, announcer, options);
var runner = new MigrationRunner(assembly, ctx, processer);
runner.MigrateUp();
}
