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; }