static void Main(string[] args)
{
Write("--Start--");
using (var connectionHolder = new ConnectionHolder(Settings.ConnectionStringFrom, Settings.ConnectionStringTo))
{
var migrator = new Migrator(connectionHolder);
DataTable sourceTablesDataTable = connectionHolder.Source.GetSchema("Tables", new string[] { null, null, null, "BASE TABLE" });
DataTable destinationDataTable = connectionHolder.Destination.GetSchema("Tables", new string[] { null, null, null, "BASE TABLE" });
var sourceTables = new List <TableDescriptor>();
foreach (DataRow row in sourceTablesDataTable.Rows)
{
sourceTables.Add(new TableDescriptor((string)row[1], (string)row[2]));
}
foreach (DataRow row in destinationDataTable.Rows)
{
string schema = (string)row[1];
string tableName = (string)row[2];
if (sourceTables.Any(td => td.Name == tableName && td.Schema == schema))
{
migrator.Copy(schema, tableName);
}
}
}
Write("--Finish--");
}
public Migrator(ConnectionHolder connectionHolder)
{
_connectionHolder = connectionHolder;
}