=?iso-8859-1?q?Migraci=F3n_/_Migrating?=

Hi! I'm working on the migration of a database from Informix to SQL Server 2000 and I have a question I hope someone can give me the answer. I need to change some data types, and I'm using "datetime YEAR to MONTH" in Informix and I don't know how to change it to SQL Server 2000. Thank you! mi email is lottofire@gmail.com Hola! Estoy trabajando en la migración de una base de datos de Informix a SQL Server 2000 y tengo una pregunta que espero alguien me pueda responder. Necesito cambiar algunos tipos de datos, estoy usando "datetime YEAR to MONTH" en Informix y no sé como cambiarlo en SQL Server 2000. Gracias! mi correo electrónico es lottofire@gmail.com =)

Assuming you are using DTS then you can map using that, there is a comparable (ish) time 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: 24 October 2006 17:29 > Posted To: comp.databases.informix > Conversation: Migraci'n / Migrating > Subject: Migraci'n / Migrating > > > Hi! > I'm working on the migration of a database from Informix to > SQL Server 2000 and I have a question I hope someone can give > me the answer. > > I need to change some data types, and I'm using "datetime > YEAR to MONTH" in Informix and I don't know how to change it > to SQL Server 2000. > > Thank you! mi email is lottofire@gmail.com > > Hola! > Estoy trabajando en la migraci'n de una base de datos de > Informix a SQL Server 2000 y tengo una pregunta que espero > alguien me pueda responder. > > Necesito cambiar algunos tipos de datos, estoy usando > "datetime YEAR to MONTH" en Informix y no s' como cambiarlo > en SQL Server 2000. > > Gracias! mi correo electr'nico es lottofire@gmail.com > > =) >