Re: Converting Access database to SQL server or Informix

Posted in 1998

Andrew Mercer — Fri, 3 Jul 1998 08:16:42 +0800 — source: Informix-list mailing list archive (1991-1998)

I have successfully used MS-Access export to move tables to Informix OnLine using ODBC. It creates and populates the tables. You have to remember that Informix has a limit of 18 chars for table, column and index names. Then you have to link the Informix tables in MS-Access. Hope this helps. Lee Chee Qwun wrote in message <6nfg9q$738$1@newton2.pacific.net.sg>... >Hi > >I have a PowerBuilder V4.0 application that uses ODBC driver to connect to >an Access 2.0 database. I am planning to convert the database to either >SQL server or Informix. > >Would appreciate if anyone can answer the following questions: > >1) Which option is easier? I heard SQL server is very similar to Access >since both are Microsoft products. Will it be much easier to convert to SQL >server? > >2) What changes must be made to the program? > >3) Will the conversion be easier if I use ODBC driver? Will ODBC driver be >significantly slower than native driver? > >Thanks >Chee Qwun > > >