Re: PLEASE HELP ME - Migrate From Access DB

Alessandro,

My company migrated an Access database to Oracle 8.1.6 for a client so it is definitely possible to do this. However, I found it quite difficult to set up the migration workbench.

You need to have a repository set up in the Oracle database. This is an account in the Oracle database that the workbench uses to store its working data. You need to be able to connect to this repository from the computer where the workbench software is running. When you have created the repository account, try connecting to it using SQL*Plus. If you can't, there might be something wrong with you network environment (what is the exact Oracle error message?).

You also need to have Microsoft Data Access Objects 3.5 installed. This comes as part of older versions of Access but not with Access 2000. If you have Access 2000 installed, you will need to install Data Access Objects 3.5 separately. I installed it from a Microsoft Visual Studio 5 disk.

After this you need to use the ODBC data source administrator to set up a data source for your Access database. You should be able to connect to the Access database using the ODBC test utility.

I don't know if it is still there, but there was an obscure bug in older versions of the migration tool. If you don't have a default printer set up for your PC, the migration tool crashed at the end of the migration process so it might be worth setting up a printer.

When all this is done, you should be able to migrate your database without trouble. If problems persist, please feel free to send me an email.

Good luck,

Richard Armstrong
richard.armstrong_at_juno.demon.co.uk

Alessandro <tamautomazione_at_tamnet.it> wrote in message news:VMHa5.87$TE6.1261_at_news.infostrada.it...
> I have the last version of Oracle Enterprise edition, i must migrate my
> access database into Oracle db, but I don't know like to do it.
>
> I try to explain me ....
>
> I know that i must to use the Migrate Workbench with the Access AddIn, but
> when the utility ask me user, password and service i don't know why I have
> the error "Listener .... Service_Name....".
>
> Before to try with Migrate WorkBench i have configured Net8 Assistant with
 a
> new servicename and the Listener .... maybe i loose something else for
> create a database migrated from access ??
>
> I use system, manager like user and password
>
> Do you know some weblink with this type of information ?
>
> Please help me
> Thanks
>
>
>
Received on Mon Jul 17 2000 - 00:00:00 CDT