public void DataTransfer_SSCE2SqlServer()
{
testContextInstance.RecordTestMethod();
DataExchangeWizard_Accessor target = null;
try
{
target = new DataExchangeWizard_Accessor(); // TODO: Initialize to an appropriate value
}
catch
{ }
CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler;
CoreEA.ICoreEAHander targetHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler;
string srcCEFile = GlobalInfo.SqlCE_TestFile;
srcHandle.Open(new LoginInfo_SSCE()
{
DbName = srcCEFile
});
List <string> tableList = srcHandle.GetTableListInDatabase();
targetHandle.Open(new CoreEA.LoginInfo.LoginInfo_SqlServer()
{
X_Server = @"VincentNotebook\SQL2008EXPRESS",
X_UserName = "******",
X_Pwd = "dfbbybf",
X_Database = "MyTestDB",
IsTrustedConn = false,
X_CurDbConnectionMode = CoreEA.Args.CurDbServerConnMode.SqlServer2000
});
List <string> targetDbList = targetHandle.GetTableListInDatabase();
foreach (var tableName in tableList)
{
BaseTableSchema schemaInfo = srcHandle.GetTableSchemaInfoObject(tableName);
if (!targetDbList.Contains(tableName))
{
targetHandle.CreateTable(schemaInfo);
try
{
CommonUtil_Accessor.ExchangeDataBetweenAnyDbs(srcHandle, targetHandle, tableName);
}
catch
{
targetHandle.DeleteTable(tableName);
}
}
}
TestGlobalExtension.RecordTestMethod();
}
public void DataTransfer_SSCE2MySQL()
{
DataExchangeWizard_Accessor target = null;
try
{
target = new DataExchangeWizard_Accessor(); // TODO: Initialize to an appropriate value
}
catch
{ }
CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler;
CoreEA.ICoreEAHander targetHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler;
srcHandle.Open(new LoginInfo_SSCE()
{
DbName = GlobalInfo.SqlCE_TestFile
});
List <string> tableList = srcHandle.GetTableListInDatabase();
targetHandle.Open(new LoginInfo_MySql()
{
Database = "category",
Server = "localhost",
Username = "******",
Pwd = "noway",
});
List <string> targetDbList = targetHandle.GetTableListInDatabase();
bool isHasError = false;
foreach (var tableName in tableList)
{
BaseTableSchema schemaInfo = srcHandle.GetTableSchemaInfoObject(tableName);
if (!targetDbList.Contains(tableName, new MyStringComparer()))
{
targetHandle.CreateTable(schemaInfo);
try
{
bool result = CommonUtil_Accessor.ExchangeDataBetweenAnyDbs(srcHandle, targetHandle, tableName);
if (result == false)
{
isHasError = true;
}
}
catch
{
targetHandle.DeleteTable(tableName);
}
}
}
Assert.AreEqual(false, isHasError);
}
public void DataTransfer_SSCE2Sqlite()
{
testContextInstance.RecordTestMethod();
DataExchangeWizard_Accessor target = null;
try
{
target = new DataExchangeWizard_Accessor(); // TODO: Initialize to an appropriate value
}
catch
{ }
CoreEA.ICoreEAHander srcHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlCE35).X_Handler;
CoreEA.ICoreEAHander targetHandle = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.Sqlite).X_Handler;
string srcCEFile = GlobalInfo.SqlCE_TestFile;
srcHandle.Open(new LoginInfo_SSCE()
{
DbName = srcCEFile
});
List <string> tableList = srcHandle.GetTableListInDatabase();
targetHandle.Open(new CoreEA.LoginInfo.LoginInfo_Sqlite()
{
DbFile = "C:\\1.sqlite",
});
List <string> targetDbList = targetHandle.GetTableListInDatabase();
foreach (var tableName in tableList)
{
BaseTableSchema schemaInfo = srcHandle.GetTableSchemaInfoObject(tableName);
if (!targetDbList.Contains(tableName))
{
targetHandle.CreateTable(schemaInfo);
try
{
CommonUtil_Accessor.ExchangeDataBetweenAnyDbs(srcHandle, targetHandle, tableName);
}
catch
{
targetHandle.DeleteTable(tableName);
}
}
}
TestGlobalExtension.RecordTestMethod();
}
