HomeOracle Page 3 - Migrating from Oracle 10G XE to SQL Anywhere 10
Using the Migrate Database Wizard in SQL Anywhere 10 - Oracle
In a previous article, a set of tables from Oracle 10G XE were transferred to SQL 2005 Server using SQL 2005 Server's Export/Import Wizard. This article is about migrating a table from Oracle 10G XE to SQL Anywhere 10.
Assuming you have started the SQL Anywhere Network Server, you can connect to the demo10 database using Sybase Central. In Sybase Central click on the main menu item Connections, and from the drop-down click on Connect with SQL Anywhere 10. In the dialog that pops up, enter the credentials and click on the Database tab. In this tabbed form, click on the drop-down related to Server Name: and choose demo10. With this you will be connected to the demo10 database and be able to access all the objects as shown in the next picture.
Stepping through the Migrate Database Wizard
You can start the wizard from the main menu as shown in the next picture by following the trail and clicking on the hyperlink, Tools -->SQL Anywhere 10->Migrate database.... This opens up the dialog as shown in the next picture.
This Welcome window explains briefly the migration process which consists of setting up a remote server on SQL Anywhere to access the database in question, which can be from any one of several vendors. Clicking on the Next button opens up the next window, where a database has to be chosen as shown. As you can see, demo10 is the only database.
Clicking on the Next button takes you to the screen where you need to Select aRemote Server from which you will be migrating. There is already one remote server, which will not be used in this tutorial.
You also have the option of creating a new remote server. For this article a new one will be created by clicking on the button Create Remote Server Now.... This opens up the window shown in the next picture by calling up the Remote Server Wizard. The naming of the remote server is important. For this tutorial the name OracleXE has been chosen.
After choosing the name, click on the button Next to choose the type of server used. The table to be migrated will come from that remote server. Several choices are shown; Oracle has been chosen.
Click on the Next button in the above window to pop open the next step of this wizard, as shown in the picture. Here you must provide the connection information. There are two choices, ODBC or JDBC. The default ODBC is the appropriate selection for the ODBC Connection that will be used. In the connection information textbox, type in the ODBC DSN created earlier, namely, JayOra.