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

The nature of the data transferred - 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.

TABLE OF CONTENTS:
  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
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

When you hit the Next button in the previous screen you will bring up the next screen, which requires you to specify what kind of data you want transferred (integrated, maybe). There are two options, to copy the tables or to bring in only what is required by writing a suitable query. For this tutorial we will be bringing a couple of tables from Oracle XE to SQL 2005 Server, so the first option is chosen.

Tables and views to copy are chosen

When you click on the Next button in the previous screen you will be presented with the next screen, where all the tables and views in the Oracle XE are shown together with individual check boxes where you may make the selection of tables/views you want to bring. For this tutorial the four tables shown earlier will be brought in.

It is also possible to edit the information transferred by hitting the Edit... button to make changes to the mapping. You also have the option of getting all the tables. For a selected table, highlighting it in the list and hitting the preview button will show the data it contains, as shown in the next screen. To exit out of this, click on the OK button.



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

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

ORACLE ARTICLES

- 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: