Re: Converting Access database to SQL server or Informix

On Wed, 8 Jul 1998 13:55:23 +0200, "Adolfo Mu'oz Aguilar" <cc0adolf@uco.es> wrote: >Lee Chee Qwun escribi' en mensaje <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. >> >First you has met care with name on fields and tables, with blank spaces and >limit size !!! >If all is right, you can download the 'upsizing tools' from microsoft web, >that's a complement to access export entery databases to Ms Sql Sever drive >by ODBC. Upsizing tools make for you: > > - Create same index. > - Make relation and integrites rules. > - Create defults for all database. > - Correct translate on autonumber fields. > >Dont'n test other products, that's best solution. The best solution should never be determined by what's the easiest way to migrate something. You have to think long range. It may be marginaly more difficult to move to an Informix database, but you'll get a better engine to run your application on. That's long range thinking. One day you'll possibly also want to move away from MS Access as a front end tool. It's fine for small things, but it definitely have it's limitations. Even using Visual Basic would be much better. Moving the application from MS Access to Visual basic, probably a pease at a time, may not be too hard. You may retain reports and some other things in MS Access, but create your user interface in Visual Basic. As your database grows you may also find it advantageous to create server side applications or even multi tier applications. At that time you should take a hard look at Java for development. That's the time you sure want to leave Microsoft behind. They haven't done anything worthwhile with or in Java. At that time another engine may also prove a significant advantage. Using Informix you will even have the option of going to the Universal Server Option giving you significant advantages at the engine side. Do check out Informix's offer for NT developers at http://www.informix.com Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)