Problem solve Get help with specific problems with your technologies, process and projects.

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?
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.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.