SEO

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