Discussion Locked

convert an access 97 db to Oracle 8i

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi all,
i have a Ms Access 97 database having 182 tables.i also have a license version of Oracle 8i personal edition.

problem :
i have an existing project in VB/Access and now for my new client, who has his other systems in Oracle , i want to convert my existing MS ACCESS database to oracle and later use ODBC to connect to the Oracle db, connecting is not a problem but conversion is something really new for me.

firstly i dont know if i need to use import/export and if any one is to be used , how???????
is it easier to export from access or import from oracle???

how do i do that.i have installed ORACLE 8i personal edition for win 98 and have my access database ready .

this is very urgent so your kind attention is neededregards
aniket bapat.

1 reply

by dennis den ouden

Hi Aniket,

What you could do is use Microsoft Visio 2000 to read the table/query layout into visio and convert it into a Oracle setup file, this setup will contain all the oracle sql coding to setup the oracle tables/views to be run in oracle sqlplus, it is also possible to completly let visio take care of the transfer database layout to Oracle

Hope this will help.
Dennis den Ouden
The Netherlands
info@comsyssup.nl

This discussion is closed to new replies.