Copying a Table from Oracle 10G XE to SQL 2000 Server using DTS
(Page 1 of 4 )
Database users sometimes need to transfer data from one vendor type to another. Sometimes data stored in a large scale database such as Oracle or MS SQL Server may be transferred to smaller desktop database applications such as MS Access, MS Visual FoxPro, etc. This tutorial is an exercise in such a transfer from Oracle 10G XE to SQL 2000 server using Data Transformation Services. I urge readers to review the articles on DTS in particular and data migration in general on the ASP Free site to get the most out of this tutorial.
Tutorial Requirements
The tutorial assumes that you have a working Oracle 10G XE program, a great product. If you do not have this product, you can install it for free. The details for getting the program and installing are discussed at this link. You must also have the MS SQL 2000 Server working on the same machine, or a connected machine. For this tutorial both programs are running on a Window XP Professional machine.
By going to Start-->All Programs-->Oracle 10G Express Edition-->Go to Database Homepage you can access the login page for the database. Assuming you have added the hr user, you can log in with the pair hr/hr and get access to the HR database. After you are authenticated you may click on the Object Browser icon to reveal the objects. From the drop-down Tables, you will be able to display all the table names. You may choose the Employee table that we will use the DTS to transfer to the SQL 2000 server. The next picture shows the design details of this table.
The following is a sample of the data from this table.
Next: Creating a New DTS Package >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
/ 6 
