SQL-Server to Oracle

   Yes.  You are essentially correct.  You do not have to open source code and regenerate the model for Oracle.  However, there is one additional piece of code that you would need to add.  That is a DataSourceMappingInterceptor.  The DataSourceMappingInterceptor is used to handle the inevitable differences between an Oracle Database and a SQL Server Database.  For example, the table owner names might be different, or you may want convert some table names to upper case.  This is some of the code that you might need for an Oracle DataSourceMappingInterceptor. 

foreach (DataColumnMapping columnMapping in info.TableMapping.ColumnMappings) {
columnMapping.SourceColumn = columnMapping.SourceColumn.ToUpper();
}
info.ConcurrencyColumnName = info.ConcurrencyColumnName.ToUpper();
if (info.ColumnInsertMap.ContainsKey("RowVersion")) {
info.ColumnInsertMap["RowVersion"] = info.ColumnInsertMap["RowVersion"].ToUpper();
}
if (info.ColumnUpdateMap.ContainsKey("RowVersion")) {
info.ColumnUpdateMap["RowVersion"] = info.ColumnUpdateMap["RowVersion"].ToUpper();

}

Once you've written one DataSourceMappingInterceptor for one application, there is a good chance that you can reuse it for other applications.

Please read the attached document on Data Transforms.

Edited by IdeaBlade - 12-Jul-2007 at 3:57pm