Copying a Table from Oracle 10G XE to SQL 2000 Server using DTS

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.


Read the full article here: Copying a Table from Oracle 10G XE to SQL 2000 Server using DTS

For more discussion go here: Blog Article Discussion