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

Extracting data from Oracle and loading into SQL Server

What are the available options of extracting data from the Oracle 8.1.7 tables and loading it into a SQL Server 2000 database server? The data needs to be extracted as a batch process or once a day and involves more than 5,000 records. Which is the best option?

What are the available options of extracting data from the Oracle 8.1.7 tables and loading it into a SQL Server 2000 database server? The data needs to be extracted as a batch process or once a day and involves more than 5,000 records. Which is the best option?
The best tool for the job is Microsoft's Data Transformation Services (DTS). First, set up an ODBC DSN to point to your Oracle database. Then, navigate to Start->Programs->Microsoft SQL Server->Import and Export Data. This program is the DTS wizard. You will first be asked for the data source. In the data source type, choose an ODBC connection and use the DSN you previously created. Next, you will be asked for the data destination. Choose your SQL Server database. You can then instruct the wizard which table(s) to tranport. At the end of the wizard, you will be asked to run the transfer immediately or to schedule it. You can save the DTS package to SQL Server and automate a batch job to execute it on a regular basis.

Dig Deeper on Oracle database design and architecture

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