Difference in Data Mappings between SQL Server 2000 and 2005?
I've noted the following using:
- SQL Developer Migration Workbench 1.2.1 Build MAIN-32.13
- Repository database Oracle 10gR2 10.2.0.3.0
When capturing a SQL Server 2000 database (Northwind) you can change the Data Mapping the SQL Server datatype DATETIME from default TIMESTAMP to DATE.
Using a SQL Server 2005 database (Northwind) as source with capture and when trying to change the default Data Mapping of SQL Server datatype DATETIME to DATE again, I have no other option than only the default TIMESTAMP.
A 'workaround' is by editing the MIGR_DATATYPE_TRANSFORM_RULE repository table and change the mapping of DATETIME from TIMESTAMP to DATE. The converted model shows that all SQL Server 2005 DATETIME datatypes are converted to Oracle DATE.
Are the Data Mapping Rules dependent on SQL Server version? I would think that with 2005 you also could map SQL Server datatype DATETIME to Oracle DATE.
Thanks,
Ed
Correct tablename is: MIGR_DATATYPE_TRANSFORM_RULE and not MIGR_DATATYPE_TRANSFORMATION_RULE
Message was edited by:
ebangma