Oracle
  Home arrow Oracle arrow Page 6 - Step-By-Step Guide to Importing Data f...
Dev Shed Forums 
Administration  
Apache  
BrainDump  
DHTML  
Flash  
Java  
JavaScript  
Multimedia  
MySQL  
Oracle  
Perl  
PHP  
Practices  
Python  
Reviews  
Security  
Style-Sheets  
Web Services  
XML  
Zend  
Zope  
Forums Sitemap 
IBM® developerWorks 
Dedicated Servers 
E-Commerce Hosting 
Linux Web Hosting 
Managed Hosting 
Small Business Hosting 
Download TestComplete 
VPS Hosting 
Weekly Newsletter

 
Developer Updates  
Free Website Content 
IBM Rational Software Development Conference
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
ORACLE

Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005
By: Jayaram Krishnaswamy
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 4 stars4 stars4 stars4 stars4 stars / 5
    2006-06-21

    Table of Contents:
  • Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005
  • Call up the wizard
  • The destination of the data
  • The nature of the data transferred
  • Saving and executing the package
  • Wizard's Summary report
  • Comparison of Department and Employees tables after importing

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
     
    ADVERTISEMENT

    Dell PowerEdge Servers

    Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005 - Wizard's Summary report
    (Page 6 of 7 )

    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


       · Importing and Exporting of data from one vendor database product to the other is an...
     

       

    ORACLE ARTICLES

    - Tuning PL/SQL Code
    - Debugging PL/SQL Code
    - Testing PL/SQL Code
    - Working With PL/SQL Code
    - Conditional Compilation for Oracle Database ...
    - Compile-Time Warnings for Oracle DB 10g
    - Compiling PL/SQL Code for an Oracle Database
    - Troubleshooting PL/SQL Code
    - Managing PL/SQL Code
    - Data Manipulation and More for HTML DB Appli...
    - Oracle Database Fundamentals
    - Adding Processes to HTML DB Applications
    - Adding Computations, Processes, and Validati...
    - Sub-templates and More with Oracle HTML DB
    - Focusing on Templates in Oracle HTML DB

     
    Accelerating Trading Partner Performance
     
    Competing on Analytics
     
    Cost Effective Scaling with Virtualization and Coyote Point Systems
     
    Five Checkpoints to Implementing IP Telephony
     
    Hosted Email Security: Staying Ahead of New Threats
     




    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway