Database Schema and Data Migration - Sybase SQL Anywhere to Oracle

SQLines and SQLData tools can help convert database schema and transfer the data from Sybase SQL Anywhere to Oracle.

• SQLData - High Performance Data Migration Tool (Free and Commercial Editions Available)

The following versions are supported:

• Sybase SQL Anywhere and Adaptive Server Anywhere (ASA) 12.x, 11.x, 10.x, 9.x, 8.x, 7.x, 6.x and 5.x
• Oracle 11g and 10g, Oracle Exadata v2 and v1

Before you can move the data you have to convert database schema (DDL statements).

If the tables do not already exist in Oracle, they need to be created using CREATE TABLE and ALTER TABLE statements that have different syntax in Sybase SQL Anywhere and Oracle.

CREATE TABLE conversion involves:

• Data Type Mapping
• User-Defined Types (UDT)
• DEFAULT Values
• AUTOINCREMENT and IDENTITY Properties
• PRIMARY and FOREIGN KEY Constraints