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 SAP Sybase ASA to SAP HANA

SAP HANA

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


Sybase ASA to SAP HANA Migration Features Overview

  • Stored Procedures, Functions and Triggers conversion
  • Built-in-functions conversion
  • DDL conversion

We propose you to have a deeper insight at the Sybase ASA to SAP HANA migration features.

Stored Procedures conversion:

  • Basic statements and syntax ( Loops, DML statatements, Cursors etc) conversion

Sybase ASA:

  1. CREATE PROCEDURE sp_loop_proc
  2. AS
  3. DECLARE @found INT
  4. DECLARE @val INT
  5. SET @found = 1
  6. SET @val = 1
  7. WHILE @found <> 0
  8. BEGIN
  9. SELECT @found = COUNT(*) FROM tsample WHERE a = @val
  10. IF @found = 0
  11. INSERT INTO tsample VALUES(@val, 1)
  12. SET @val = @val+1
  13. END
  14. SELECT @val

SAP HANA:

  1. CREATE PROCEDURE sp_loop_proc
  2. LANGUAGE SQLSCRIPT
  3. AS
  4. DECLARE found INTEGER;
  5. DECLARE val INTEGER;
  6. BEGIN
  7. found := 1;
  8. val := 1;
  9. WHILE :found <> 0
  10. DO
  11. SELECT COUNT(*) INTO found FROM tsample WHERE a = :val;
  12. IF :found = 0 THEN
  13. INSERT INTO tsample VALUES(:val, 1);
  14. END IF;
  15. val := :val+1;
  16. END WHILE;
  17. SELECT :val FROM DUMMY;
  18. END;

Stored Function conversion:

  • Basic statements and syntax (Loops, DML statements, Cursors etc) conversion
  • IN, OUT, INOUT parameters

Sybase ASA:

  1. CREATE FUNCTION BONUS(@salary INT, @grade INT, @dept_id INT)
  2. RETURNS INT
  3. AS
  4. BEGIN
  5. DECLARE @bonus INT
  6. DECLARE @cat INT
  7. SET @bonus = 0
  8. SELECT @cat = dept_cat FROM department
  9. WHERE dept_id = @dept_id
  10.  
  11. IF (@cat < 10)
  12. BEGIN
  13. SET @bonus = @salary *15/100
  14.  
  15. END
  16. ELSE
  17. BEGIN
  18. SET @bonus = @salary * 10/100
  19. END
  20. RETURN @bonus
  21. END

SAP HANA:

  1. CREATE PROCEDURE BONUS(OUT RETURNVAL INTEGER,
  2. v_salary INTEGER, v_grade INTEGER, v_dept_id INTEGER)
  3. LANGUAGE SQLSCRIPT
  4. AS
  5. v_bonus INTEGER;
  6. v_cat INTEGER;
  7. BEGIN
  8. v_bonus := 0;
  9. SELECT dept_cat INTO v_cat FROM department
  10. WHERE dept_id = :v_dept_id;
  11.  
  12. IF (:v_cat < 10) THEN
  13.  
  14. v_bonus := :v_salary*15/100;
  15. ELSE
  16. v_bonus := :v_salary*10/100;
  17. END IF;
  18. RETURNVAL := :v_bonus;
  19. END;

Triggers conversion:

  • Basic statements and syntax conversion

Sybase ASA:

  1. CREATE TRIGGER TEST_TRIGGER_VAR_UPDATE
  2. ON TARGET FOR UPDATE, DELETE, INSERT
  3. AS
  4. INSERT INTO SAMPLE_TR VALUES (CURRENT_TIME(), USER)

SAP HANA:

  1. CREATE TRIGGER TEST_TRIGGER_VAR_UPDATE
  2. AFTER UPDATE OR DELETE OR INSERT
  3. ON TARGET
  4. BEGIN
  5. INSERT INTO SAMPLE_TR VALUES(CURRENT_TIME, CURRENT_USER);
  6. END;

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 Sybase ASA 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).

Why Ispirer MnMTK for Migrating from Sybase ASA 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 Sybase ASA 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 Sybase ASA to SAP HANA we are right here to help you!

Try the Toolkit

Ispirer MnMTK 2017

Sybase ASA to SAP HANA

Data and SQL SQL Data

Estimate Your Project

Ispirer MnMATK 2017

Sybase ASA to SAP HANA

Download

Purchase the Toolkit

Ispirer MnMTK 2017

Sybase ASA to SAP HANA

Data and SQL SQL Data

Purchase Service

Ispirer Migration Service

Sybase ASA to SAP HANA

Data and SQL SQL Data

You can also reach us via Contacts page.

 
SAP HANA Database

SAP HANA SP08 and earlier

Sybase ASA Databases

Sybase Adaptive Server Anywhere (ASA), Sybase SQL Anywhere 17.x, 16.x, 12.x, 11.x, 10.x, 9.0, 8.0.x, 7.0.x, 6.0.x, 5.5 and 5.0

Feedback

We’re successfully tested the tool and we’re interested in buying the licence.

Read more
Industry Events