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

The destination of the data - 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

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
 

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: