Home arrow Oracle arrow Page 2 - Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005

Call up the wizard - Oracle

Many enterprises need to move data from one kind of data source to another. This tutorial guides you through the steps necessary to move data from Oracle XE into a SQL 2005 Server database.

  1. Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005
  2. Call up the wizard
  3. The destination of the data
  4. The nature of the data transferred
  5. Saving and executing the package
  6. Wizard's Summary report
  7. Comparison of Department and Employees tables after importing
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 7
June 21, 2006

print this article



Right click on the Management folder and choose the Import Data ... menu item from the drop-down.

This wakes up the Import/Export Wizard as seen in the next picture. You can see that wizard packs a lot of tricks. It creates packages that do the final trick.

The source of the data

When you click on the button Next in the previous window, the window shown next, SQL Server Import and Export Wizard,  pops up. In this window, you must indicate where the data to be imported is presently residing. The defaults assumed are the local SQL 2005 server (Hodentek/Mysorian); Windows Authentication; the default datasource - SQLClient and a database <default> as shown here.

Since the data resides in Oracle XE, click on the drop-down for the data sources and choose the Microsoft Oledb Provider for Oracle as shown here.

After making the above choice, if you click on the Next button you will face the next window, where you need to provide the Oracle XE related information. It is assumed that Oracle XE has already been started, otherwise you may get a not found error. For the Data Source: textbox you enter xe (not case sensitive), for the user name and password you enter hr, hr (forget Scott/Tiger). Also place a check mark in the Allow saving password checkbox. You may also verify that the connection was successful by clicking on the Test button.

>>> More Oracle Articles          >>> More By Jayaram Krishnaswamy

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Java Security Woes Continue
- Oracle's New IaaS Cloud Option: There's a Ca...
- Oracle Acquires Eloqua to Boost Cloud Presen...
- Choosing Innovation: Oracle Survey Insights
- Oracle Fixes Privilege Escalation Bug
- Oracle`s Communications Service Availability...
- Oracle Releases Exalytics, Taleo Plans
- Oracle Releases Communications Network Integ...
- Oracle Releases Communications Data Model 11...
- Oracle Releases PeopleSoft PeopleTools 8.52
- Oracle Integrates Cloudera Apache Distro, My...
- Oracle Releases MySQL 5.5.18
- Oracle Announces NoSQL Database Availability
- Sorting Database Columns With the SELECT Sta...
- Retrieving Table Data with the LIKE Operator

Developer Shed Affiliates


Dev Shed Tutorial Topics: