Transcript Ispirer Systems Ltd.

SQL Server to MySQL
Database Migration
SQLWays - Migration Software
Presentation
Copyright (c) 1999-2012 Ispirer Systems Ltd. All Rights Reserved.
www.ispirer.com
Challenges
Microsoft SQL Server to MySQL migration can
be a very challenging process, particularly if
you need to convert a lot of:
● T/SQL Stored Procedures and Functions
● 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,
Triggers
What database API is used in your
applications, and how many native SQL Server
statements are used:
ODBC, JDBC, ADO.NET
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, identity properties
● Converts integrity constraints - primary and
foreign keys, unique and check constraints
● Converts comments
● Resolves reserved words and identifiers conflicts
● Transfers data (including TEXT and IMAGE data
types)
● Indexes, Views and Logins
● T/SQL Stored Procedures, Functions 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 SQL Server, 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:
● SQL Server 2012, 2008, 2005, 2000, 7.0
and 6.5
● 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