Transcript Ispirer Systems Ltd.

Oracle to MySQL
Database Migration
SQLWays - Migration Software
Presentation
Copyright (c) 1999-2012 Ispirer Systems Ltd. All Rights Reserved.
www.ispirer.com
Challenges
Oracle to MySQL migration can be a very
challenging process, particularly if you need to
convert a lot of:
● PL/SQL Stored Procedures and Functions
● PL/SQL Packages
● Triggers
● Native SQL Statements in Applications
Assessment
Assessment helps you define the cost and risk associated
with migration:
What database objects and how many of them you will need
to migrate:
Tables, Views, Procedures, Functions,
Packages, Triggers
What programming language (Java, C++, C#, VB, etc.) and
database API are used in your applications, and how many
native Oracle SQL statements they contain:
ODBC, JDBC, ADO.NET, OCI, Pro*C/C++
Why SQLWays
~100% Automation of All 3 Stages Consistent and Integrated
● Stage 1: Database schema/DDL, serverside business logic (procedures, triggers,
etc.)
● Stage 2: Data transfer and validation
● Stage 3: Front-end application code and
SQL queries/scripts
Why SQLWays
Fast Customization – Fixes, custom
conversions and optimizations within 1-2
business days
Pre-Sale Engagement – We demonstrate full
conversion during the evaluation before you
make a decision
Low Cost – We offer flexible pricing
Optimized Conversion - Intelligent and
maintainable code, no Ispirer's middleware is
used after conversion
Features
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 CLOB and BLOB data types)
● Indexes, Views, and Synonyms
● Sequences (converts to AUTO_INCREMENT)
● PL/SQL Stored Procedures, Functions,
Packages and Triggers
SQLWays Tool Features
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
Command Line Support can help you
automate the migration process
Engagement Process
How do we get started?
Assessment
Pre-Sale Engagement
● Option 1 - Sending Scripts to Ispirer team
● Option 2 – Trying SQLWays Express
version and using Fast Customization
services
Database Versions
SQLWays supports the following database
versions:
● Oracle 11g, 10g, 9i, 8i, 8.0.x and 7.x
● MySQL 5.x, 4.x and 3.23
About Ispirer
Ispirer is a MySQL/Sun Gold Partner that
specializes in database and application migration
software and services
● Database Migration for MySQL
Migration from Oracle, Sybase, IBM DB2,
Microsoft SQL Server, Informix, Teradata,
PostgreSQL, Progress, and other databases
● Application Conversion for MySQL
Application conversion: C++, Java, COBOL,
PowerBuilder, VB, C#/VB.NET, ASP, Informix
4GL, Progress 4GL, Delphi
Company
Ispirer Systems has been working in the database and
application migration field since 1999.
More than 400 companies worldwide use our software
including financial institutions and global corporations from
Fortune 500 and Global 2000:
Microsoft, HP, Citigroup, ChevronTexaco, JP Morgan, EDS, Shell,
Fujitsu, Accenture, Carrefour, CAP Gemini, Thomson and many
others
Offices:
● Beach Haven Crest, NJ, United States
● Seattle, WA, United States
● Oxon, Oxford, United Kingdom
● Minsk, Belarus
More Information
For more information about company,
migration software and services, please visit
our site or contact us by email:
● http://www.ispirer.com
Ispirer Systems Ltd. web site
● [email protected]
Product related and business inquiries
● [email protected]
Technical support