public void Start()
{
logger.Info("Db migration started..");
var upgrader = DeployChanges.To
.SqlDatabase(dbConnectionProvider.GetConnectionString())
.WithTransaction()
.WithScripts(new ScriptProvider(scriptDirectoryProvider, "schema"))
.WithScripts(new ScriptProvider(scriptDirectoryProvider, "data"))
//.JournalTo(new CustomJournal())
.LogTo(new LogProvider())
.Build();
try
{
var result = upgrader.PerformUpgrade();
if (!result.Successful)
{
logger.Error(result.Error);
Environment.ExitCode = -1;
return;
}
logger.Info("Db Update Successful!");
Environment.ExitCode = 0;
}
catch (Exception e)
{
logger.Error(e);
Environment.ExitCode = -1;
}
}
public UnitOfWork(IDbConnectionProvider dbConnectionProvider)
: base(dbConnectionProvider.GetConnectionString())
{
this.dbConnectionProvider = dbConnectionProvider;
}
