SQL Server to My SQL Database Migration SQLWays
SQL Server to My. SQL Database Migration SQLWays - Migration Software Presentation March 2009 Copyright (c) 1999 -2009 Ispirer Systems Ltd. All Rights Reserved. www. ispirer. com
Challenges Microsoft SQL Server to My. SQL 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 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 – Free 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 - Flexible pricing starting at $495 Optimized Conversion - Intelligent and maintainable code, no any Ispirer's middleware 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 and using Fast Customization services
Database Versions SQLWays supports the following database versions: ● SQL Server 2008, 2005, 2000, 7. 0 and 6. 5 ● My. SQL 5. x and 4. x
About Ispirer is a My. SQL/Sun Gold Partner that specializes in database and application migration software and services ● Database Migration for My. SQL Migration from Oracle, Sybase, IBM DB 2, Microsoft SQL Server, Informix, Teradata, Postgre. SQL, Progress and other databases ● Application Conversion for My. SQL Application conversion: C++, Java, Power. Builder, VB, C#/VB. NET, Informix 4 GL, Progress 4 GL, 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, Chevron. Texaco, JP Morgan, EDS, Shell, Fujitsu, Accenture, Carrefour, CAP Gemini, Thomson and many others Offices: ● San Mateo, CA ● Berlin, NJ ● 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 ● ispirer@ispirer. com Product Related and Business Inquiries ● support@ispirer. com Technical Support
- Slides: 12