Re: Migrating Access to Oracle

KIM wrote:
>
> Has anyone had any luck migrating Access to Oracle.
> I would like to kepp the front end tools (forms, queries, reports...) but
> change the database to Oracle due to growth in number of records.
>
> Any help would be appeciated.
>
> TIA

Hi,

we migrated from Acces2 to Oracle. We have a VB3.0 front-end which was updated to met the needs of Oracle and performance. We took this way:

We created empty tables.
We attached the tables into our access tables via ODBC. MAde some processing do tomore restrictiv constraints in our oracle db. We made insert-queries to fill the oracle tables. Remember: to add or change records of an oracle table from acces you've to define a primary key on the oracle-table. Otherwise your oracle table will be read-only, if you're able to see records at all.

So the attached oracle table can be used in queries the same way acces table do. Remember that pass-through-queries are much more perormant.- But with these queries you've got to use oracle's SQL.

There is one pitfall concerning programming when using attached oracle tables: you can't use table-object. So all code you've written with seek and setting index to use has to be rewritten using Select-Statements. Also all datacontrol or the aquivalent in access where you use a table as recordsource, the recordsource has to be changed into an Select-Statement.

-- 
Regards

Matthias Gresz    :-)