Re: Moving tables from Access to Oracle

Steve Kay <steve_at_starbug1.demon.co.uk> wrote:

>
>
>Anybody have any advice on the process of moving Access tables over
>to Oracle tables?
>
>We've got a load of tables which need moving over, but Microsoft tell
>us that once a table has been created in Access, its SQL definition
>is lost and therefore has to be recreated manually in Oracle.
>
>Any ideas or solutions for this bummer of a job?

Not so, why just the other day I loaded a load of tables into Access from SQL Server, then exported them to Oracle, including data.

After lunch I reverse engineed them into Designer 2000 for subsequant re-design. Note that the primary/foreign keys will not be transferred, but they should be easy to re construct.

You have to be aware that the datatypes may require adjusting in Access to work in Oracle, and to rename the table to get them into UPPERCASE.
>
>Thanks,
>

 Thats O
>Steve Kay.
>d- s+ a- US++ p-- w x++ b++ DI++++ G e* h--
Received on Thu Apr 18 1996 - 00:00:00 CEST