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

Storing data in Oracle 9i and SQL Server 2005

I am storing data in Oracle 9i. The same data should also be dumped in SQL Server 2005. Both the databases have the same table structure. I am not aware of any method to do this task.

I am new to Oracle and storing data in Oracle 9i. The same data should also be dumped in SQL Server 2005. Both the databases have the same table structure. But I am not aware of any method to do this task. Please help me and provide a viable solution.
The easiest way is to:
  1. Create CSV dumps of data and load into SQL Server via DTS packages.
  2. Create an ODBC connection from SQL Server to Oracle and again load it via DTS packages.
  3. You can use a number of ETL products like Oracle OWB, Informatica, etc. to accomplish this, however these tools are quite expensive.

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