Re: Migration access2000 -> 8.1.7 win2000

Create an ODBC-Connection (System-DSN) in the control-panel to your Database first. Then select each table and export them (File-Save as/Export), select external Database, select ODBC (last entry) as filetype, confirm tablename, select the previos createt DSN and enter passwort ect.

Then alter the tables in Oracle and add a primary-key (unique) to each table you want to write to, add the necessary indexes and set the desired permissions. If you have auto-increment fileds in Access then you have to use some triggers and sequences to increment the fields on the next insert.

Then delete all tables in access (or rename them to *_old) and use "File-External Data-Link Tables" to make a connection to the oracle tables. Select ODBC again, choose the right DSN and mark all tables you wish to reimport. If you are asked to select a uinique field in some tables, you may have forgotten to create some PK in the previous chapter. Rename all tables to the previous names - et voila - you are working with the Oracle database.

Maybe you have to adapt your queries to Oracle Syntax if you use some SQL-Statements because oracle doesn't like the left/right-join parameters. Instead you have to use something like "table1.filed1 = table2.field2 (*)".

Finished.

Maybe you can keep some tables in Access (configuration data, local logging, ect) but you should avoide a join between two different tables because each time a join is performed, Access will import all data from the remote-table into a temporary table to perform the join.

If you are short of time (and you won't learn by doing the previous steps) you can also download a utility from Oracle which will convert your DB the easy way.

Martin

"_at_nnibale" wrote:
>
> Hello,
>
> I need to migrate my access2000 DB to Oracle8.1.7. (server) on win2k.
> How can i do ?
>
> Thanks.
> Regards
>
> _at_nnib...new in the game
Received on Wed Mar 28 2001 - 13:31:07 CEST