Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MS SQLServer to Oracle data migration - info needed
You also might look into Oracle's Heterogeneous Services. This lets a
Oracle database create DB links to other databases.
The catch is that you'd have to have a SQL Server ODBC driver. If your Oracle database is on Unix you're not going to find a free ODBC driver for SQL Server. There might also be some conversion problems with some datatypes and 70 Gig is a lot of data to be moving through ODBC.
Steve...
"Andy" <enzoweb_at_hotmail.com> wrote in message
news:8d4033cd.0204302052.74db2618_at_posting.google.com...
> I have been asked to look at migrating 70Gb of data from a MS
> SQLServer system into Oracle (yay).
>
> My first thought is to extract the data to flat files and use SQL
> Loader to pump it into Oracle. They will probably want to do some data
> cleansing so there will probably be an intermediate step to do that.
>
> Has anyone else done a SQLServer to Oracle migration, and if so, how?
>
> Thanks
Received on Wed May 01 2002 - 07:59:44 CDT