public static Config.ImportActionMiniModel MigModelToMiniModel(Config.ImportActionModel model)
{
Config.ImportActionMiniModel minmodel = new Config.ImportActionMiniModel();
minmodel.database1 = model.database1.source + "_" + model.database1.database;
minmodel.database2 = model.database2.source + "_" + model.database2.database;
minmodel.importthreadcount = model.importthreadcount;
minmodel.insertpagesize = model.insertpagesize;
minmodel.cutomsactions = model.cutomsactions;
minmodel.getpagesize = model.getpagesize;
minmodel.excepttables = model.excepttables;
return(minmodel);
}
public static Config.ImportActionModel MigMiniModelToModel(List <Config.Database> dbs1, List <Config.Database> dbs2, Config.ImportActionMiniModel action)
{
Config.ImportActionModel newaction = null;
if (action != null)
{
Config.Database db1 = null;
Config.Database db2 = null;
foreach (var a in dbs1)
{
if (a.source + "_" + a.database == action.database1)
{
db1 = a;
break;
}
}
foreach (var a in dbs2)
{
if (a.source + "_" + a.database == action.database2)
{
db2 = a;
break;
}
}
if (db1 != null && db2 != null)
{
Config.ImportActionModel model = new Config.ImportActionModel();
model.database1 = db1;
model.database2 = db2;
model.importthreadcount = action.importthreadcount;
model.insertpagesize = action.insertpagesize;
model.excepttables = action.excepttables;
model.getpagesize = action.getpagesize;
model.cutomsactions = action.cutomsactions;
newaction = model;
}
}
return(newaction);
}
public DataMig(Config.ImportActionModel actmodel)
{
this.actmodel = actmodel;
using (var dbconn1 = DbConn.CreateConn(DbType.SQLSERVER, actmodel.database1.source, actmodel.database1.port, actmodel.database1.database, actmodel.database1.userid, actmodel.database1.password))
{
dbconn1.Open();
DbStructure.IDbStructure dbstru = new DbStructure.DbStructureSqlServer();
tables = dbstru.GetTables(dbconn1);
}
if (actmodel.excepttables != null)
{
foreach (var a in actmodel.excepttables)
{
tables.RemoveAll(x => x.name == a);
}
}
foreach (var a in tables)
{
TableMig tm = new TableMig(actmodel, a.name);
tablemigs.Add(tm);
}
}
public TableMig(Config.ImportActionModel actmodel, string tablename)
{
this.actmodel = actmodel;
this.tablename = tablename;
}
