private static void MigrateDbViews()
{
Helper.Log("Start migrating database views");
DataTable dt = SQLSvrDbi.GetViews();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
DbModule module = new DbModule(row["SchemaName"].ToString(),
row["ViewName"].ToString(), row["ViewDefinition"].ToString(),
ModuleType.View);
module.Migrate();
}
}
Helper.Log("Finished migrating database views");
}
private static void MigrateDbStoredProcedures()
{
Helper.Log("Start migrating stored procedures");
DataTable dt = SQLSvrDbi.GetStoredProcedures();
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
DbModule module = new DbModule(
row["SchemaName"].ToString(), row["ProcedureName"].ToString(),
row["ProcedureDefinition"].ToString(), ModuleType.StoredProcedure);
module.Migrate();
}
}
Helper.Log("Finished migrating stored procedures");
}