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:
side business logic (procedures, triggers, etc.) Database schema/DDL, server ●
Stage 2:
Data transfer and validation ●
Stage 3:
Front-end application code and SQL queries/scripts
Why SQLWays
Fast Customization
business days – Fixes, custom conversions and optimizations within 1-2
Pre-Sale Engagement
make a decision – We demonstrate full conversion during the evaluation before you
Low Cost
– We offer flexible pricing
Optimized Conversion
used after conversion Intelligent and maintainable code, no Ispirer's middleware is
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 ●
Product related and business inquiries ●
Technical support