HomeOracle Page 6 - Step-By-Step Guide to Importing Data from Oracle XE to SQL 2005
Wizard's Summary report - 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.
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.