By default, ABL DATE and DATETIME data types were mapped to MS SQL Server DATETIME data types. However, the migration tool provides you with the option of selecting the following datetime data type mapping:
OpenEdge Data Type
MSS Data Type
DATE
DATE
DATETIME
DATETIME2
DATETIME-TZ
DATETIMEOFFSET
To override the default mapping and choose a mapping to the data types supported by MS SQL Server 2008, uncheck the Map to MSS 'Datetime' Type option in the OpenEdge to MS SQL Server Conversion Advanced Options dialog (You can open this dialog by clicking the Advanced button on the OpenEdge DB to MS SQL Server Conversion dialog.)
Do not uncheck the Map to MSS 'Datetime' Type option if your migration target is not an MS SQL Server 2008 database or above.
Date time related data types introduced with MS SQL Server 2008 will work only with the SQL Native Client 10 (SNAC 10) driver or above, and not with earlier native and non-native drivers.
