Home arrow Oracle arrow 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.

TABLE OF CONTENTS:
  1. Migrating from Oracle 10G XE to SQL Anywhere 10
  2. Initial steps to take before migration
  3. Using the Migrate Database Wizard in SQL Anywhere 10
  4. Continuing the migration
  5. Finishing the migration
By: Jayaram Krishnaswamy
Rating: starstarstarstarstar / 9
July 19, 2006

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Logging on to demo10 database

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 a Remote 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.



 
 
>>> 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: