Informix CSV extract conversion to SQL Server 2000
Posted on 2007-08-10
I have a CSV extract of an informix database, I'm wanting to import the data into sql server 2000 along with the table properties.
I do not have access to informix.
I notice I have a syscolumns table the same as I would have in SQL which has a coltype column, however I dont have a systypes table which tells me what data type each number relates to.
does anyone have a conversion table e.g. where I have coltype = 6 in my informix table it tells me what data type that equates to in sql.
also any code that looks at my informix tables and imports them directly into SQL would be appreciated.