SEO

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

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
>

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

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