Re: MS Access 97 -> Oracle 8i migration problem

Is it all text and numbers? Assuming you have no embedded objects or other binary data, you can write a script in Access to export tables to a text file, and then use the Oracle tools to import the file. You can do the same for table relationships, indexes, etc. but if the database is not terribly complex it's probably easier to reconstruct those manually.

  -Matt

On Fri, 3 Sep 1999 10:43:35 +0200, "Thierry Jouin" <thierry_at_rmm.fr> wrote:

>We are trying to migrate our MS Access database to Oracle 8i database. We've
>got the Oracle 8.0.5 NT Client and an Oracle 8i serveur on Digital Unix. We
>download the MS Access to Oracle 8i Migration Toolkit for NT, but it need
>the Oracle Universal Installer. There is no Universal Installer with Oracle
>8.0.5 NT Client, isn't it ? We have some question :
>Is there an Oracle 8i Client for NT already available ?
>How can we migrate for MS Access DB to Oracle 8i (Digital Unix) DB easylier
>as possible (with the migration toolkit for example) ?
>Thanks for all
>Cheers
>
>--
>Thierry Jouin
>Groupe Multimédia
>
>
>
Received on Fri Sep 03 1999 - 12:56:54 CDT