THIS SITE USES COOKIES: By continuing to browse this site, you give your consent for cookies to be used.
For more details, please read our Privacy Policy and Cookies Policy.

Automated and Customizable
Database and Application
Migration and Modernization

Migrate MySQL to SAP HANA

SAP HANA

Ispirer MnMTK is a powerful tool that automatically converts database schema (DDL), data and server-side business logic from MySQL to SAP HANA and can be customized in compliance with our client’s requirements. We help our clients to understand the value of automated database and application migration solutions that enable business growth!


MySQL to SAP HANA Migration Features Overview

The toolkit migrates the following database objects and properties to SAP HANA:

  • Stored Procedures, Functions and Triggers conversion
  • Schema (DDL) conversion
  • Indexes and Views conversion
  • Transfers Data

DDL conversion:

  • Converts columns definitions - data types, default values, NOT NULL constraints
  • Converts primary and foreign keys

MySQL:

  1. CREATE TABLE product_description (
  2. `ID` INT(11) NOT NULL,
  3. `CATEID` INT(11) DEFAULT NULL,
  4. `LINEID` INT(11) DEFAULT NULL,
  5. `NAME` VARCHAR(50) DEFAULT NULL,
  6. `DESCRIPTION` VARCHAR(50) DEFAULT NULL,
  7. `CATENAME` VARCHAR(50) DEFAULT NULL,
  8. `CATEDESCRIPTION` VARCHAR(50) DEFAULT NULL,
  9. `LINENAME` VARCHAR(50) DEFAULT NULL,
  10. `LINEDESCRIPTION` VARCHAR(50) DEFAULT NULL,
  11. `PRODDATE` datetime DEFAULT NULL,
  12. PRIMARY KEY (`ID`)
  13. );
  14.  

SAP HANA:

  1. CREATE TABLE product_description
  2. (
  3. ID INTEGER NOT NULL,
  4. CATEID INTEGER DEFAULT NULL,
  5. LINEID INTEGER DEFAULT NULL,
  6. NAME VARCHAR(50) DEFAULT NULL,
  7. DESCRIPTION VARCHAR(50) DEFAULT NULL,
  8. CATENAME VARCHAR(50) DEFAULT NULL,
  9. CATEDESCRIPTION VARCHAR(50) DEFAULT NULL,
  10. LINENAME VARCHAR(50) DEFAULT NULL,
  11. LINEDESCRIPTION VARCHAR(50) DEFAULT NULL,
  12. PRODDATE TIMESTAMP DEFAULT NULL,
  13. PRIMARY KEY(ID)
  14. );
  15.  

Stored Procedures conversion:

  • Converts procedures syntax and statements
  • Converts variables and parameters
  • Converts comments

MySQL:

  1. CREATE PROCEDURE CursorProc (INOUT prod_list VARCHAR(4000))
  2. BEGIN
  3.  
  4. DECLARE v_finished INTEGER DEFAULT 0;
  5. DECLARE v_prod VARCHAR(100) DEFAULT "";
  6. DECLARE prod_cursor CURSOR FOR
  7. SELECT name FROM product_description;
  8. DECLARE CONTINUE HANDLER
  9. FOR NOT FOUND SET v_finished = 1;
  10. OPEN prod_cursor;
  11. get_prod: LOOP
  12. FETCH prod_cursor INTO v_prod;
  13. IF v_finished = 1 THEN
  14. LEAVE get_prod;
  15. END IF;
  16. SET prod_list = CONCAT(v_prod,";",prod_list);
  17. END LOOP get_prod;
  18. CLOSE prod_cursor;
  19. END;
  20.  

SAP HANA:

  1. CREATE PROCEDURE CursorProc(INOUT prod_list VARCHAR(4000))
  2. LANGUAGE SQLSCRIPT
  3. AS
  4. v_finished INTEGER DEFAULT 0;
  5. v_prod VARCHAR(100) DEFAULT '';
  6.  
  7. CURSOR prod_cursor FOR
  8. SELECT name FROM product_description;
  9.  
  10. BEGIN
  11.  
  12. DECLARE EXIT HANDLER
  13. FOR NOT FOUND v_finished := 1;
  14. OPEN prod_cursor;
  15.  
  16. LOOP
  17. FETCH prod_cursor INTO v_prod;
  18. IF :v_finished = 1 THEN
  19. BREAK;
  20. END IF;
  21. prod_list := :v_prod || ';';
  22. END LOOP;
  23.  
  24. CLOSE prod_cursor;
  25.  
  26. END;
  27.  

MySQL:

  1. CREATE PROCEDURE `DropCreateTabProc`()
  2. BEGIN
  3. DROP TABLE IF EXISTS HANATEST.ProductLevel;
  4. CREATE TABLE ProductLevel(
  5. ID INT ,
  6. PRODUCT INT ,
  7. PRLEVEL INT ,
  8. MINLEVEL INT ,
  9. MAXLEVEL INT
  10. );
  11. END;
  12.  

SAP HANA:

  1. CREATE PROCEDURE DropCreateTabProc LANGUAGE SQLSCRIPT
  2. AS
  3. v_if_exists INTEGER;
  4. BEGIN
  5.  
  6. v_if_exists := 0;
  7. SELECT COUNT(*) INTO v_if_exists FROM "PUBLIC"."M_TABLES"
  8. WHERE schema_name = 'HANATEST' AND TABLE_NAME = 'PRODUCTLEVEL';
  9. IF :v_if_exists > 0 THEN
  10. DROP TABLE ProductLevel;
  11. END IF;
  12.  
  13. CREATE TABLE ProductLevel
  14. (
  15. ID INTEGER,
  16. PRODUCT INTEGER,
  17. PRLEVEL INTEGER,
  18. MINLEVEL INTEGER,
  19. MAXLEVEL INTEGER
  20. );
  21.  
  22. END;
  23.  

Stored Functions conversion:

  • Converts syntax and statements
  • Converts variables and parameters
  • Converts comments

MySQL:

  1. CREATE FUNCTION CurVarFunc(var INT)
  2. RETURNS INT(11)
  3. BEGIN
  4. DECLARE var1 INT;
  5. DECLARE v_i CURSOR FOR SELECT employeeNumber FROM employees;
  6. DECLARE v_i1 CURSOR FOR SELECT employeeNumber FROM employees_audit;
  7. IF var = 1 THEN
  8. OPEN v_i;
  9. fetch v_i INTO var1;
  10. close v_i;
  11. END IF;
  12. IF var <> 1 THEN
  13. OPEN v_i1;
  14. fetch v_i1 INTO var1;
  15. close v_i1;
  16. END IF;
  17. RETURN var1;
  18. END;
  19.  

SAP HANA:

  1. CREATE PROCEDURE CurVarFunc(OUT RETURNVAL INTEGER,var INTEGER)
  2. LANGUAGE SQLSCRIPT
  3. AS
  4. var1 INTEGER;
  5. CURSOR v_i FOR SELECT employeeNumber FROM employees;
  6. CURSOR v_i1 FOR SELECT employeeNumber FROM employees_audit;
  7. BEGIN
  8.  
  9. IF :var = 1 THEN
  10. OPEN v_i;
  11. fetch v_i INTO var1;
  12. close v_i;
  13. END IF;
  14. IF :var != 1 THEN
  15. OPEN v_i1;
  16. fetch v_i1 INTO var1;
  17. close v_i1;
  18. END IF;
  19. RETURNVAL := :var1;
  20. END;
  21.  

Triggers conversion:

MySQL:

  1. CREATE TRIGGER before_employee_update
  2. BEFORE UPDATE ON employees FOR EACH ROW
  3. BEGIN
  4.  
  5. INSERT INTO employees_audit(id, actionc, employeeNumber, lastname,
  6. changedon)
  7. VALUES (OLD.id, 'update', OLD.employeeNumber, OLD.lastname, NOW());
  8.  
  9. END;
  10.  

SAP HANA:

  1. CREATE TRIGGER before_employee_update
  2. BEFORE UPDATE
  3. ON employees
  4. REFERENCING OLD ROW OLD
  5. FOR EACH ROW
  6. BEGIN
  7.  
  8. INSERT INTO employees_audit
  9. (id, actionc, employeeNumber, lastname, changedon)
  10. VALUES(:OLD.id, 'update', :OLD.employeeNumber, :OLD.lastname,
  11. CURRENT_TIMESTAMP);
  12.  
  13. END;
  14.  

More possibilities:

  • Besides the server-side business logic, Ispirer MnMTK also converts SQL queries in front-end applications and scripts to conform with SAP HANA syntax.
  • Moreover, our tool is also capable of converting MySQL procedural code to Java and .NET.
  • Make considerable time-savings and automate your migration process thanks to Command Line Support: set up the conversion scheduling or launch a conversion into your development process.
  • Compare the number of tables, the number of rows with the help of our toolkit and perform Migration Validation for all or just selected columns (based on primary keys or specified order clause).

The following online presentation shows an example of MySQL to SAP HANA database migration:




Why Ispirer MnMTK for Migrating from MySQL to SAP HANA?

Ispirer Systems strives to perform high-grade and first-class database migration. We tailor our migration tool Ispirer MnMTK in such a way that a customized version can fully satisfy a client's business needs.

Our main advantages:

  • 100% Automation of All 3 Stages - Consistent and Integrated
    • Stage 1: Database schema/DDL, server-side business logic (procedures, triggers etc);
    • Stage 2: Data transfer and validation;
    • Stage 3: Front-end application code and SQL queries/scripts;
  • Flexible pricing: we can offer you a wide range of options, among which you will definitely find the one which suits you;
  • Customer-oriented approach and Fast Customization: we personalize our migration tool in such a way that a customized version can fully satisfy our client’s business needs, custom conversions and optimizations are made within 1-2 business days;
  • Pre-Sales Engagement: we demonstrate a full conversion during the evaluation before you make a decision.
  • Optimized Conversion: after the conversion you get an intelligent and maintainable code, without using any Ispirer's middleware.

Why Ispirer Service for Migrating from MySQL to SAP HANA?

In addition to our toolkit we offer you to take advantage of our Service! Just let us manage your whole migration project on our side and we’ll help you to assess, design, implement and, finally, to test the migration.

Main benefits of Ispirer Service:

  • Fast time-to-solution;
  • Highly qualified migration experts;
  • Reducing operating costs.

Thanks to the tremendous experience in database migration, we could find a solution to the most complicated task!


When you need to migrate from MySQL to SAP HANA we are right here to help you!

Try the Toolkit

Ispirer MnMTK 2017

MySQL to SAP HANA

Data and SQL SQL Data

Estimate Your Project

Ispirer MnMATK 2017

MySQL to SAP HANA

Download

Purchase the Toolkit

Ispirer MnMTK 2017

MySQL to SAP HANA

Data and SQL SQL Data

Purchase Service

Ispirer Migration Service

MySQL to SAP HANA

Data and SQL SQL Data

You can also reach us via Contacts page.

 
MySQL Database

MySQL 5.x, 4.x and 3.23

SAP HANA Database

SAP HANA SP08 and earlier

Testimonials
November 27, 2013NTT DATA, India
Oracle to MySQL Migration

"We were looking for a tool that would help us to migrate automatically our Oracle database to MySQL without any manual work. Finally we found SQLWays migration tool...

...

June 18, 2009Synnex Corporation, United States
Sybase to MySQL Migration

"I used SQLWays to convert Sybase tables, views and especially 4000+ stored procedures to MySQL successfully. The tool is very flexible to automatically implement...

...

Case Studies
June 20, 2018Progress 4GL to .NET C# WinForms Solution, United States

Company offerings include customer relationship management (CRM), supply chain management (SCM), and human capital management (HCM) software.

Company serves over 20,000 customers in 150...

...

April 28, 2018Informix 4GL to Microsoft SQL Server Solution, United States

Our Customer is a trusted US corporation that provides human resources services and business solutions for more than 100,000 small and midsized businesses across the United States.

...

Feedback

Now the developers know your tool works fine…
Thanks for your assistance and we take into account Ispirer for this migration or any other we have to do in the future.

Read more
Industry Events