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

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