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


COBOL to Transact-SQL Migration


Ispirer helps to convert COBOL applications to Microsoft SQL Server T-SQL.

Over more than 15 years hundreds of migration projects have been realized using our migration and modernization software and services.

Assessment Process

The assessment of your migration project could definitely help to weigh up efforts and the approximate cost of your migration. For detailed process of assessment please refer to the following link:

COBOL Migration Assessment

In order to facilitate the process, you're welcome to fill in our:


COBOL Application Migration Questionnaire


Live Presentation

Ispirer Migration Solution

COBOL to Transact-SQL

Request

Request a Quote

Ispirer Migration Solution

COBOL to Transact-SQL

Service Toolkit


COBOL Program Structure

  1. IDENTIFICATION DIVISION.
  2. PROGRAM-ID. DemoId.
  3. ENVIRONMENT DIVISION.
  4. DATA DIVISION.
  5. PROCEDURE DIVISION.
  6. FIRST-PARAGRAPH.
  7. DISPLAY "First DEMO".


There are the four divisions:

  • IDENTIFICATION DIVISION: This is where you must enter the program name.
  • ENVIRONMENT DIVISION: This is where you define the files the program needs.
  • DATA DIVISION: This is where you declare variables, records, files etc.
  • PROCEDURE DIVISION: This is where you write the program. In the sample above this is all in one paragraph. A paragraph is a series of statements named by a label. There is no specific mark to the end of a paragraph.


Conversion features

  • Converts COBOL’s programs to SQL Server procedure
    1. CREATE PROCEDURE DemoId() AS
    2. BEGIN
    3. PRINT ‘FIRST DEMO’
    4. END;

  • Converts WORKING-STORAGE section with declaration variables and records to MS SQL Server DECLARE
    1. WORKING-STORAGE SECTION.
    2. 01 MY_STRING_1 PIC X(20).
    3. 01 MY_STRING_2 PIC X(30).
    4. 01 MY_NUMBER PIC 9(2) VALUE 1.

    To:

    1. DECLARE
    2. @MY_STRING_1 VARCHAR(20),
    3. @MY_STRING_2 VARCHAR(20),
    4. @MY_NUMBER INT
    5. SET @MY_NUMBER=1

  • Converts COBOL records to MS SQL Server CLR user-defined type
    1. 01 MY_DATA_RECORD.
    2. 03 MY_NAME PIC X(20).
    3. 03 MY_ADDRESS PIC X(40).
    4. 03 MY_ID PIC 9(2).

    To:

    1. CREATE TYPE MY_DATA_RECORD AS TABLE
    2. (MY_NAME VARCHAR(20),
    3. MY_ADDRESS VARCHAR(40),
    4. MY_ID INT )
    5. GO

  • Converts COBOL MOVE TO/COMPUTE statements to SET assignment statements
    1. MOVE 5 TO MY_NUMBER.

    To:

    1. SET @MY_NUMBER=5

  • Converts COBOL sections (group of paragraphs or statements) to MSSQLServer procedures. The SECTION could be called using PERFORM statement. PERFORM is converted to EXECUTE of stored procedure.
  • Converts COBOL control structures to Microsoft SQL Server control statements
    1. IF condition
    2. ELSE
    3. END IF

    To:

    1. IF condition
    2. ELSE
    3. END IF;
    And
    1. PERFORN UNTIL condition
    2. COBOL statements
    3. END-PERFORM

    To:

    1. WHILE condition
    2. sql_statements/sql_block

  • Converts Screen output (DISPLAY statement) to PRINT statement
  • Converts EXEC SQL/ END-EXEC(select, insert, update, delete, CURSOR statements) statements to MSSQLServer SQL statements (SELECT, INSERT, UPDATE, DELETE, CURSOR statements)
    1. EXEC SQL
    2. SELECT cur_date
    3. FROM val_date
    4. WHERE cur_date < CURRENT
    5. END-EXEC.

    To:

    1. SELECT cur_date
    2. FROM val_date
    3. WHERE cur_date < GetDate();

  • Automatically converts SQL statements in Embedded SQL (EXEC SQL/END-EXEC.) to conform to MSSQLServer T/SQL

Why Ispirer MnMTK

Ispirer MnMTK can help you automatically convert your current COBOL application. It also eliminates most of risks and reduce total amount of required efforts significantly. All these benefits are available at very reasonable and competitive costs, which makes database and application migration tool even a more attractive instrument for this project type. Ispirer MnMTK is also a very flexible conversion tool. Any migration direction can be developed further. It can provide conversion in the shortest terms.

You are welcome to contact us for more information.

 
Testimonials
December 3, 2012Epicor Software Corporation, United States
Progress 4GL to C# .Net Migration

"Epicor has engaged with the Ispirer team to create and refine prototype techniques for migrating certain parts of the Epicor Progress ABL code to well...

...

Case Studies
May 26, 2014COBOL to .NET Conversion, United States

Our client was a major player in market-driven innovation and science. For more than two hundred years, it has been presenting world-class science and engineering to the global marketplace...

...

September 12, 2014Delphi to C# .NET, United States

Our client was a U.S.-based health insurance company providing care services since six decades through its extensive network of hospitals and other institutions.

...

Feedback

Thanks again for the demo of the tool. As I mentioned during the demo, the capabilities look impressive!

Read more
Industry Events