Oracle
  Home arrow Oracle arrow Page 3 - Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005
Dev Shed Forums  
Administration  
AJAX  
Apache  
BrainDump  
DHTML  
Flash  
Java  
JavaScript  
Multimedia  
MySQL  
Oracle  
Perl  
PHP  
Practices  
Python  
Reviews  
Security  
Smartphone Development  
Style-Sheets  
Web Services  
XML  
Zend  
Zope  
Mobile Linux  
App Generation ROI  
IBM® developerWorks  
Forums Sitemap  
E-Commerce Hosting  
Linux Web Hosting  
Managed Hosting  
Small Business Hosting  
VPS Hosting  
Weekly Newsletter

 
Developer Updates  
Free Website Content 
 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? 
Google.com  
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: starstarstarstarstar / 6
    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:
      error-file:tidyout.log Del.ici.ous error-file:tidyout.log Digg
      error-file:tidyout.log Blink error-file:tidyout.log Simpy
      error-file:tidyout.log Google error-file:tidyout.log Spurl
      error-file:tidyout.log Y! MyWeb error-file:tidyout.log 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


    Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005 - The destination of the data
    ( Page 3 of 7 )

    The destination for purposes of this tutorial is the SQL 2005 Server (Microsoft SQL Server Management Studio 9.00.1399.00). When you click the OK button to the previous screen you get the following window.

    Since the tables imported will go into a database in SQL 2005, you need to specify  an existing database, or create a new one. The server name is automatically entered as shown. Click on the ellipsis button, New ... in the above screen to bring up the Create Database window shown in the next screen.

    You need to give a name to this database, which is Imported10g for use in this tutorial. The rest of the information gets filled in as shown. It essentially creates the data file Imported10g_data.mdf and log file Imported10G_log.ldf in the correct directories. As to the file sizes and their growth, you may make changes should you so desire. Here the defaults are used.

    When you hit the OK button you have completed configuring the destination for the data, which is shown in the next screen. The database Imported10g will be created if everything goes according to the plan.



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

       

    ORACLE ARTICLES

    - Oracle's Turn to Play in the Sun
    - Implementing and Using Oracle`s Restore Poin...
    - 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...





    © 2003-2009 by Developer Shed. All rights reserved. DS Cluster 2 Hosted by Hostway
    For more Enterprise Application Development news, visit eWeek