RE: How to map data

Maybe reading the SqlServer DTS manuals would help? Wouldn't you have a similar problem if your data source was Oracle? Perhaps this is a question for Sqlserver forums moreso than informix? -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Rodolfo Sent: Tuesday, October 31, 2006 5:58 PM To: informix-list@iiug.org Subject: How to map data Hi everybody! I'm working on a migration from Informix to SQL Server... I'm doing it through DTS and ODBC. What I'm doing is using the DTS, my data origin is tha Informix database and mi target is the SQL Server database that I just created, this is via IBM Informix ODBC and I copy the tables... but the results are something like this: --INFORMIX-- create table r_cap_dbt_uni ( num_db smallint , cve_uni char (8) , fecha_mens datetime YEAR to MONTH , valor float , primary key ( num_db, cve_uni, fecha_mens ) , foreign key ( num_db ) references cat_db_tec ( num_db ) ); -- SQL SERVER -- create table r_cap_dbt_uni ( num_db smallint , cve_uni char (8) ,*********************************************** fecha_mens smalldatetime , valor float , *********************************************** primary key ( num_db, cve_uni, fecha_mens ) , foreign key ( num_db ) references cat_db_tec ( num_db ) ); as you can see the float and datetime year to month data types change like the example before.... I changed the "float" datatype manually to "decimal" datatype... but I don't know what to do with the "datetime year to month" Informix datatype, I mean, I dn't know why the DTS changes this datatype to "smalldatetime"... how can I map this? what's the process? Thank you very much! Rodolfo _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ============================================================ The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any reproduction, dissemination or distribution of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Tellabs ============================================================