Migrating from Informix to Access

Hi all, I need to migrate an informix xx.xx database running on a SCO UNIX to a MSaccess (or Oracle) database, how can I do it?? which kind of software do I need?? thanks in advance Bye Andrea Bellinzaghi

On Fri, 18 Feb 2000 15:23:59 +0100, "Andrea Bellinzaghi" <andrea.bellinzaghi@cisi.it> wrote: >Hi all, > >I need to migrate an informix xx.xx database running on a SCO UNIX to a >MSaccess (or Oracle) database, how can I do it?? which kind of software do >I need?? > >thanks in advance > >Bye > >Andrea Bellinzaghi > This is Q for ORACLE/Access group. Anyway, why are You doing that? Don't do it.

Try WinSQL Professional at http://www.imranweb.com/freesoft. This tool allows you to write a SQL query against on source, in your case Informix, and export the result into another, in your case Oracle. Thanks, Andrea Bellinzaghi wrote: > Hi all, > > I need to migrate an informix xx.xx database running on a SCO UNIX to a > MSaccess (or Oracle) database, how can I do it?? which kind of software do > I need?? > > thanks in advance > > Bye > > Andrea Bellinzaghi -- ===================================================================== Imran Hussain imranh@imranweb.com For FREE Software visit http://www.imranweb.com/freesoft =====================================================================

Andrea Bellinzaghi wrote: > Hi all, > > I need to migrate an informix xx.xx database running on a SCO UNIX to a > MSaccess (or Oracle) database, how can I do it?? which kind of software do > I need?? > > thanks in advance > > Bye > > Andrea Bellinzaghi If you are only concerned with the data and not the applications, then, you can always unload the data into a falt file and, load it into the respective database using the facilities available on the RDMS of your choice. (some data has no data type in the other databases and so you have to chose what you want to do with them.) To move the schema to another database you can use dbschema to create an SQL file, again you may have to edit this file before you can use it with the your RDMS choice of migration. -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web) For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------

If you install the informix odbc driver and point it at your database you can import directly into access. Before doing this you should ask yourself again why you are doing this and is using access really a good idea. In article <88jkhn$6cho$1@stargate1.inet.it>, Andrea Bellinzaghi <andrea.bellinzaghi@cisi.it> wrote: >Hi all, > >I need to migrate an informix xx.xx database running on a SCO UNIX to a >MSaccess (or Oracle) database, how can I do it?? which kind of software do >I need?? > >thanks in advance > >Bye > >Andrea Bellinzaghi > > -- ================ http://www.clark.net/pub/phil/index.html ================ | Phil | "Simplicity is beautiful." Columbia, MD | -- Juliana Hatfield

I do some work with Access as a client to Informix and I can think of a number of reasons for migrating some or all of a database to Access. Here are just a couple that I have faced: (1) You need to do some work offsite on just a part of the data (whether or not you may want to append something back later), but it's not a regular thing that would warrant replication. (2) You have a smaller client for the same application and want to create an Access multiuser database. I agree that the easiest way is to use the Informix ODBC drivers, link the tables, and create MakeTable queries to create the tables in Access. You'll probably have to re-create the client application if it is not already in Access. * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!