Informix CSV extract conversion to SQL Server 2000
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.
Thanks
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.
Thanks
Aneesh
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/infmxsql.mspx
If you've got an odbc driver for your version of informaix, you can add it as a sql linked server, and select directly from it.
ASKER
I don't have access to informix...
Ah yes.
Well, your options are
Data Transformation Services (DTS)
Bulk Copy Program (BCP)
Linked server using text driver to .csv file
Well, your options are
Data Transformation Services (DTS)
Bulk Copy Program (BCP)
Linked server using text driver to .csv file
ASKER
bulk copy program? - through a package or something else?
got 1,315 tables... so DTS is no good without spending all day.
a conversion table which tells me what the data types in informix equates to in sql is the main goal.
got 1,315 tables... so DTS is no good without spending all day.
a conversion table which tells me what the data types in informix equates to in sql is the main goal.
BCP is a command line program - run it from a DOS command shell.
"got 1,315 tables... so DTS is no good without spending all day"
It's going to take a while, whichever of the 3 options you use - each needs specific info for each file.
"a conversion table which tells me what the data types in informix equates to in sql is the main goal."
Have a look at this - you need to go through 2 steps - informix to odbc to sql server (under Data Type Mappings towrads then end of the page)
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/infmxsql.mspx#ETAAK
"got 1,315 tables... so DTS is no good without spending all day"
It's going to take a while, whichever of the 3 options you use - each needs specific info for each file.
"a conversion table which tells me what the data types in informix equates to in sql is the main goal."
Have a look at this - you need to go through 2 steps - informix to odbc to sql server (under Data Type Mappings towrads then end of the page)
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/infmxsql.mspx#ETAAK
ASKER
like I say I don't have access to informix.
"like I say I don't have access to informix."
sry - I don't follow. There are 2 tables on that page
first one maps sql datatypes to odbc, second maps informix to odbc, therefore, you have informix to sql indirectly.
sry - I don't follow. There are 2 tables on that page
first one maps sql datatypes to odbc, second maps informix to odbc, therefore, you have informix to sql indirectly.
ASKER
unless im missing something (could you cut and paste for me).
im looking for a table that tells me what the number equates to in the coltype column within the syscolumns table.
e.g. where I have coltype = 6 in my informix table something that tells me what data type that equates to in sql.
this table would be called systypes within SQL.
thanks
im looking for a table that tells me what the number equates to in the coltype column within the syscolumns table.
e.g. where I have coltype = 6 in my informix table something that tells me what data type that equates to in sql.
this table would be called systypes within SQL.
thanks
ahhh - i see - the tables on that page give you names, not numbers....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.