Migration

Posted in 2006

Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Migration, Import/Export & Data Conversion

Rodolfo — 31 Oct 2006 07:45:23 -0800 — source: Usenet: comp.databases.informix

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 this migration? Thanks! My email is lottofire@gmail.com Rodolfo

↪ replying to Rodolfo

Paul Watson — Tue, 31 Oct 2006 10:00:13 -0600 — source: Usenet: comp.databases.informix

SQL Server doesn't have DATETIME AFAIR so you need to map it to a SQL type, you should be beable to map it to DATE as well Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THERE FASTER with Informix. Attend IDUG 2007 San Jose, North America May 6-10, 2006 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: Rodolfo [mailto:lottofire@gmail.com] > Posted At: 31 October 2006 09:45 > Posted To: comp.databases.informix > Conversation: Migration > Subject: Migration > > > 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 > this migration? > > > Thanks! > > > My email is lottofire@gmail.com > > > Rodolfo >

↪ replying to Paul Watson

Rodolfo — 31 Oct 2006 14:55:36 -0800 — source: Usenet: comp.databases.informix

Could you explain me how to map it to SQL? thanks in advance Rodolfo Paul Watson wrote: > SQL Server doesn't have DATETIME AFAIR so you need to map it to a SQL > type, you should be beable to map it to DATE as well > > Paul Watson > Tel: +44 1414161772 > Mob: +44 7818003457 > Web: www.oninit.com > > GO FURTHER with DB2 > GET THERE FASTER with Informix. > Attend IDUG 2007 San Jose, North America > May 6-10, 2006 > Visit http://www.iiug.org/conf for more information. > > > > > > -----Original Message----- > > From: Rodolfo [mailto:lottofire@gmail.com] > > Posted At: 31 October 2006 09:45 > > Posted To: comp.databases.informix > > Conversation: Migration > > Subject: Migration > > > > > > 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 > > this migration? > > > > > > Thanks! > > > > > > My email is lottofire@gmail.com > > > > > > Rodolfo > >

↪ replying to Paul Watson

Rodolfo — 31 Oct 2006 15:48:52 -0800 — source: Usenet: comp.databases.informix

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 Paul Watson wrote: > SQL Server doesn't have DATETIME AFAIR so you need to map it to a SQL > type, you should be beable to map it to DATE as well > > Paul Watson > Tel: +44 1414161772 > Mob: +44 7818003457 > Web: www.oninit.com > > GO FURTHER with DB2 > GET THERE FASTER with Informix. > Attend IDUG 2007 San Jose, North America > May 6-10, 2006 > Visit http://www.iiug.org/conf for more information. > > > > > > -----Original Message----- > > From: Rodolfo [mailto:lottofire@gmail.com] > > Posted At: 31 October 2006 09:45 > > Posted To: comp.databases.informix > > Conversation: Migration > > Subject: Migration > > > > > > 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 > > this migration? > > > > > > Thanks! > > > > > > My email is lottofire@gmail.com > > > > > > Rodolfo > >

↪ replying to Rodolfo

ifxmaillist@quanta.co.nz — Wed, 1 Nov 2006 15:54:43 +1300 — source: Usenet: comp.databases.informix

DTS creates the tables as it thinks you might like them given the information in its translation table. If the table is not correct then you need to go through the database and alter each column to what you want it to be. Similarly serial columns are created as integer but without the Identity set - you must set that manually. MW -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Rodolfo Sent: Wednesday, 1 November 2006 12:49 p.m. To: informix-list@iiug.org Subject: Re: Migration 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 Paul Watson wrote: > SQL Server doesn't have DATETIME AFAIR so you need to map it to a SQL > type, you should be beable to map it to DATE as well > > Paul Watson > Tel: +44 1414161772 > Mob: +44 7818003457 > Web: www.oninit.com > > GO FURTHER with DB2 > GET THERE FASTER with Informix. > Attend IDUG 2007 San Jose, North America > May 6-10, 2006 > Visit http://www.iiug.org/conf for more information. > > > > > > -----Original Message----- > > From: Rodolfo [mailto:lottofire@gmail.com] > > Posted At: 31 October 2006 09:45 > > Posted To: comp.databases.informix > > Conversation: Migration > > Subject: Migration > > > > > > 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 > > this migration? > > > > > > Thanks! > > > > > > My email is lottofire@gmail.com > > > > > > Rodolfo > > _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list