Re: MS SQLServer to Oracle data migration - info needed

Tarik wrote:

> Niall
>
> Sorry I didn't make it clear: I was assuming that the tables had
> already been designed and defined in the Oracle database, and so all
> you have to do is to attach the tables to the Access database from
> both the Oracle and SQL Server databases. The point being that Access
> doesn't have to do anything other than run the query.
>
> You're absolutely right you wouldn't want to extract the data into
> Access first and then try and create them in Oracle from Access - a
> bit akin to the old joke about gyneacology!
>
> I use this technique a lot, when, believe it or not, I have to move
> data out of an HP IMAGE database into an Oracle database - fortunately
> I don't have to do this the other way around!
>
> Tarik

Your original assessment is valid. Just dump the data from SQL Server as ASCII files and use SQL*Loader. 70GB is a reasonable amount of data so look up the requirements for using 'direct path' and use it if at all possible.

Daniel Morgan Received on Wed May 01 2002 - 10:44:54 CDT