I’m not sure if this has been covered elsewhere but any help re this would be appreciated:
When I try and use the native Toad Data Point import function to take a table via ODBC from an old Informix 7.32 table which has some date columns in it into SQL Server it fails.
The cause seems to be the import feature of Toad always sees the date columns as datatype “timestamp” rather than “date” and can’t process timestamp fields/columns with explicit values.
Manually forcing the datetype within the Toad Import steps to be “date” makes little difference.
I can get the data in the table into Informix by first saving to a CSV file & storing the date columns as type CHAR or VARCHAR then taking that into SQL Server but I have rather a lot of these Informix tables to take over.
Thanks in advance