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

Converting SQL Server data to Oracle

I have SQL Server and Oracle 9i on my system. I need some code or program so that I can convert my SQL Server data into Oracle data. Tools are available but I want to learn programatically to convert data between heterogeneous databases.

I have SQL Server and Oracle 9i on my system. I need some code or program so that I can convert my SQL Server data into Oracle data. Tools are available but I want to learn programatically to convert data between heterogeneous databases.
My best advice is to use one of the following options to migrate data between SQL Server and Oracle:
  1. Migration Workbench
  2. You can use Oracle Warehouse Builder (OWB) or any ETL toolset to move data between non-Oracle and Oracle databases.
  3. Unload data into CSV flat files from the non-Oracle source and load it into Oracle using SQL*Load, the Oracle external table feature or any ETL toolset (like OWB, Informatica, etc.).

Dig Deeper on Oracle data and application integration

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.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close