Ask the Expert

Best way to move data from SQL Server to Oracle

How would I pull data from tables in a SQL Server database into an Oracle database? Do I need to use an ODBC connection, move the data into flat files, and then use SQL*Loader to populate the tables in the Oracle database? Or is there an easier way?

    Requires Free Membership to View

If you are going to need this data moved on a regular basis, then I'd investigate using Oracle's Heterogeneous Services (HS) to establish the connectivity to SQL using HS's generic connectivity via ODBC drivers.

If using HS isn't an option for you or you can't handle the limitations of that solution, or if you just need to move data one time, then:
-- investigate generation of a flat file (using isql's bcopy feature probably) that could be loaded with SQL*Loader on Oracle.
-- investigate using an ODBC driver to connect to Oracle and SQL at the same time via a front-end like MS Access or similar tool and transfer the data directly using that tool.

This was first published in June 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: