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
> >