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

Wizard's Summary report - 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 click on the Next button you will see the following screen, which summarizes the actions that will be taken by the wizard.

Package execution

When you click on the Finish button, the package will be executed. It will show the following screen, which will be progressively filled as each step of the package is executed. Error messages are shown as hyperlinks for the error message content in the message column, should they appear. The hyperlinks may also be read for other messages.  No errors were reported for this package.

Result of import

This next window shows the screen shot of the fully expanded 10g database in SQL Server 2005's Management Studio. In the next section the same tables in SQL Server 2005 and Oracle 10g are compared.



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