public void ImportDataFromSQLServerToOracle(string sqlcon, string oraclecon)
{
string[] TableNameFilter = new[] { "Table1", "Table2" };
SchemaMapper.Exporters.OracleExport expOralce = new SchemaMapper.Exporters.OracleExport();
using (SchemaMapper.Converters.SqlServerCeImport ssImport = new SchemaMapper.Converters.SqlServerCeImport(sqlcon))
{
ssImport.getSchemaTable();
foreach (DataRow drRowSchema in ssImport.SchemaTable.AsEnumerable().Where(x =>
TableNameFilter.Contains(x["TABLE_NAME"].ToString())).ToList())
{
string SQLTableName = drRowSchema["TABLE_NAME"].ToString();
string SQLTableSchema = drRowSchema["TABLE_SCHEMA"].ToString();
DataTable dtSQL = ssImport.GetDataTable(SQLTableSchema, SQLTableName);
using (SchemaMapper.SchemaMapping.SchemaMapper sm = new SchemaMapper.SchemaMapping.SchemaMapper(SQLTableSchema, SQLTableName))
{
foreach (DataColumn dc in dtSQL.Columns)
{
SchemaMapper_Column smCol = new SchemaMapper_Column();
smCol.Name = dc.ColumnName;
smCol.Name = dc.ColumnName;
smCol.DataType = smCol.GetCorrespondingDataType(dc.DataType.ToString(), dc.MaxLength);
sm.Columns.Add(smCol);
}
expOralce.CreateDestinationTable(sm, oraclecon);
expOralce.InsertUsingOracleBulk(sm, dtSQL, oraclecon);
//there are other methods such as :
//expOralce.InsertIntoDb(sm, dtSQL, oraclecon);
//expOralce.InsertIntoDbWithParameters(sm, dtSQL, oraclecon);
}
}
}
}
