MySQL/Sun Enterprise Gold Partner

Migrate Oracle to MySQL


SQLWays is used to smoothly migrate Oracle to MySQL!

This powerful tool converts database schema (DDL), data and server-side business logic from SQL Oracle to MySQL and can be customized at a client’s request.


Oracle to MySQL Migration Overview

The tool migrates the following database objects and properties from Oracle to MySQL:

  • Tables and Data
    • Converts columns definitions - data types, default values, NOT NULL constraints
    • Converts integrity constraints - primary and foreign keys, unique and check constraints
    • Converts comments
    • Resolves reserved words and identifiers conflicts
    • Transfers data (including LONG, CLOB and BLOB data types)
  • Indexes, Views and Synonyms
  • Sequences (converts to AUTO_INCREMENT column properties)
  • PL/SQL Stored Procedures, Packages, Functions and Triggers

Besides server-side business logic, SQLWays also converts SQL queries in front-end applications and scripts.

SQLWays is capable of converting Oracle PL/SQL code to Java and .NET.

Ispirer Systems strives to render world-class database migration services. We tailor our migration tool SQLWays in such a way that a customized version can fully satisfy a client's business needs. We steamroll through the industry with our best-in-class conversion tool SQLWays and are glad to share with you a recorded demo showing an example of Oracle to MySQL database migration:



In the demo you will see how database migration tool SQLWays converts functions, triggers, stored procedures, packages, synonyms, user-defined types, views and tables.

Other Materials:

SQLWays Tool Features for Oracle to MySQL Migration

  • Quick and Useful Conversion of SQL Scripts - You can easily start converting existing SQL scripts - DDL statements, database SQL dump, SQL queries etc.
  • Conversion with Database Connection - SQLWays can connect to Oracle, extract and convert the entire database or just specified objects and schemas
  • Generates SQL scripts in MySQL syntax
  • Generates LOAD DATA INFILE commands for importing data into MySQL (LOBs are supported)
  • Command Line Support can help you automate the migration process
  • Migration Validation - The tool can compare the number of tables, the number of rows, and perform data validation for all or selected columns (based on primary keys or specified order clause)

Why SQLWays for Migrating from Oracle to MySQL

SQLWays and our support ensure low cost and nearly 100% automation of the entire Oracle to MySQL migration.

  • ~100% Automation of All 3 Stages - Consistent and Integrated
    • Stage 1: Database schema/DDL, server-side business logic (PL/SQL stored procedures, packages, triggers etc)
    • Stage 2: Data transfer and validation
    • Stage 3: Front-end application code and SQL queries/scripts
  • Fast Customization - Free fixes within 1-2 business days

  • Pre-Sale Engagement - We demonstrate full conversion during the evaluation before you make a decision. Engagement Process

  • Low Cost - We offer flexible pricing

  • Optimized Conversion - Intelligent and maintainable code, no any Ispirer's middleware used after conversion

Read more about SQLWays Key Benefits.

To order a demo of SQLWays migration software please go to Download. To find out about our pricing policy go to Purchase. You can also reach us via Contacts page.


Download / Purchase

Oracle to MySQL Database Migration Tools

Oracle to MySQL Data Migration Tool

This version of our migration tool is capable of converting tables and data (converts columns definitions, integrity constraints, comments; resolves reserved words and identifiers conflicts; transfers different data types), indexes and sequences. Learn more...

download | purchase

Oracle to MySQL SQL Migration Tool

This version of our migration tool converts PL/SQL stored procedures, packages, functions and triggers with or without database connection. It is also capable of PL/SQL scripts conversion. Learn more...

download | purchase

Oracle to MySQL Database Migration Tool

This version of our migration tool converts tables and data, as well as all the other database objects (PL/SQL stored procedures, packages, functions and triggers) with or without database connection. It is also capable of converting PL/SQL scripts. Learn more...

download | purchase



Oracle to MySQL Embedded SQL and Database Access API Conversion Tools

Oracle to MySQL Java Embedded SQL Conversion Tool

This version of our migration tool helps you to perform automatically comprehensive assessment and conversion of embedded SQL statements in Java applications. With our conversion tool there is no need to extract SQL statements from application code and convert them separately. The conversion tool completes the whole migration process internally. Learn more...

download | purchase

Oracle Pro*C to MySQL С API Conversion Tool

This version of our migration tool automatically detects EXEC SQL statements and host variables in Oracle Pro*C applications and converts them to MySQL С API and pastes additional code. With our conversion tool there is no need to extract EXEC SQL statements from application code and convert them separately. The conversion tool completes the whole migration process internally. Learn more...

download | purchase

Other Embedded SQL and Database Access API Conversion Tools you can find here.



Oracle to MySQL Application Migration Tools

Oracle Forms to C#.NET Migration Tool

This version of our migration tool is capable of converting Oracle Forms to C#.NET. The migration tool automates the entire migration process of your current Oracle Forms application to C#.NET. Learn more...

download | purchase

Other Application Migration Tools you can find here.

 
online presentation
live presentation
download sqlways free express version
download a demo
purchase license
SQLWays for MySQL
MySQL Databases

MySQL 5.x, 4.x and 3.23

Oracle Databases

Oracle 12с, 11g, 10g, 9i, 8i, 8.0.x and 7.x

Oracle Exadata v2 and v1

Testimonials
October 9, 2013Ventyx, Australia
DB2 LUW to Oracle on Linux Migration

"To whom it may concern,
My name is Bill Lloyd and I work as a Senior DBA for Ventyx, a leading software company supplying software products primarily to the...

...

October 1, 2013Andsome&Company, Korea
DB2 AS400 to Oracle Migration

"Andsome&Company Co., Ltd. have used SQLWays for 2 months in process of converting existing DB2 in AS400 to Oracle 11g release 2 both data and sources. ...

Case Studies
September 13, 2014Visual Basic to Visual Basic.NET Migration, United States

A consulting company from the United States focusing on enterprise mobile device management and delivering solutions to solve business problems addressed to Ispirer because of the necessity to...

...

September 12, 2014Deplhi to C# .NET Migration, United States

Our client was a health insurance company operating for more than 60 years in the United States. It offers wide choice in hospitals and other institutions providing care services.

...

News
Events