Intelligent, Custom and Highly Automated Cross Platform Database and Application Migration

Migrate Sybase ASE to SAP HANA

SAP HANA

This powerful tool converts database schema (DDL), data and server-side business logic from Sybase ASE 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 ASE 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 ASE to SAP HANA migration features.

Stored Procedures conversion:

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

Sybase ASE:

  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 ASE:

  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 ASE:

  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;


The following demo presentation shows an example of Sybase ASE to SAP HANA database migration:



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 ASE 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 ASE 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 ASE 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 ASE to SAP HANA we are right here to help you!

Try the Toolkit

Ispirer MnMTK 2015

Sybase ASE to SAP HANA

Data and SQL SQL Data

Estimate Your Project

Ispirer MnMATK 2017

Sybase ASE to SAP HANA

Download

Purchase the Toolkit

Ispirer MnMTK 2015

Sybase ASE to SAP HANA

Data and SQL SQL Data

Purchase Service

Ispirer Migration Service

Sybase ASE 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 ASE Database

Sybase Adaptive Server Enterprise (ASE) 16.x, 15.x, 12.5.x, 12.0, 11.x and earlier

Testimonials
January 2, 2017Wine & Vinos GmbH, Germany
Progress to Microsoft SQL Server

"We had to change our ERP System from an old one based on Progress Database. We chose Microsoft Dynamics NAV and had to migrate data from the old Progress...

...

November 29, 2016La Nacional Corp., United States
Sybase ASA to MS SQL Server

"We recognized the urgent need to perform the database migration from outdated Sybase ASA to Microsoft SQL Server. Having tried various migration options available...

...

Case Studies
August 18, 2014Sybase to PostgreSQL Migration, United States (including embedded SQL migration)

Our client was a U.S.-based broadcasting and cable company that develops contemporary and futuristic conditional access technologies, and supports infrastructure deployed by major operators...

...

February 5, 2014Sybase ASE to Oracle and Sybase ASE to Microsoft SQL Server Migration, United Kingdom/United States

Our client was Global Investment Bank (GIB), a provider of investment banking advisory services. Besides financing, risk management, and corporate finance advisory services, it provides foreign...

...

Feedback

I just want to touch base with you to let you know that the tool is doing great work so far.

Read more
Industry Events