Re: MS SQLServer to Oracle data migration

From: Ivan <igvasquez_at_hotmail.com>
Date: Wed, 1 May 2002 14:47:59 -0400
Message-ID: <aapd8v$isr$1@cronkite.cc.uga.edu>

Since you already have SQL Server, I'd use DTS. To get to Oracle, you can choose whatever middleware you want (ODBC, Oracle for OLEDB, Microsoft OLEDB for Oracle), regardless of what it is running on.

Instead of creating 70GB worth of flat files, create a temp schema in Oracle with your tables but no constraints (to reduce chance of failed transfers). Once in Oracle you can do the cleanup.

You could also use bcp in SQL Server and sqlLoader in Oracle, but if you want things quick and easy, that'd be the way to go.

Ivan.

"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 - 13:47:59 CDT

Re: MS SQLServer to Oracle data migration - info needed