Posted by Rodolfo on 10/31/06 15:42

Hi everybody!

I have migrated some tables from a database in Informix to a database
in SQL Server 2000 using the DTS via ODBC. I installed the Informix
Client SDK in order to make my conection.

I did the tables migration but I'm using in the Informix table the
datatype DATETIME YEAR TO MONTH (and some others similar) but when
migrating to SQL Server 2000 the DTS change the datatype to
SMALLDATETIME!

Is it correct the procedure? is there another way of checking thsi
migration?

Thanks!

My email is lottofire@gmail.com

Rodolfo

[Back to original message]