October 5, 2005 at 9:38 am
i need support to migrate a database from informix 4gl to sql server. If anyone can help me, very been thankful.
October 10, 2005 at 8:00 am
This was removed by the editor as SPAM
October 11, 2005 at 3:00 pm
I've migrated from Informix On-Line on a Solaris machine that used 4gl to SQL-Server. What are you trying to convert: the tables, the SQL queries, the forms?
I've used both bcp and DTS to transfer data from the tables. I did work out a translation from that converted some of my SQL. The big thing that I remember was converting the ; at the end of a statement to a newline and GO. There is no good transference of 4gl forms. We wrote Visual Basic applications to replace some of them and use MS-Access linked to the SQL-Server tables for some of the ad-hoc queries or simple data entry.
I hope this helps.
Steve
December 6, 2006 at 1:11 pm
has anyone else done this? I'm looking where to get the software needed to connect to Informix from SQL
December 6, 2006 at 2:17 pm
If you are going to connect to Informix from SQL Server you need an ODBC driver to connect to it. Data Direct has some drivers (www.datadirect.com/products/odbc) but you probably can get them other places.
With ODBC, you can use DTS (including the Import/Export Wizard) to create the tables and move the data without writing any scripts. You will probably have to recreate the indexes, primary keys, etc. after the Import from Informix to SQL Server.
It's been a while since I did this and the ODBC drivers I used then are probably no longer in existence, but if you have any other questions I will try to answer them.
Steve
December 18, 2006 at 8:22 am
I am looking at Converting an Informix 9.3 Datawarehouse to Sql Server. I will keep you posted on anything i find. Please let me know if you have found anything good.
Cheers,
Michael
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply