COBOL to SQL Server Migration

SQLWays is capable of converting COBOL applications to Microsoft SQLServer T/SQL.

COBOL Program Structure

IDENTIFICATION DIVISION.
PROGRAM-ID. DemoId.
ENVIRONMENT DIVISION.
DATA DIVISION.
PROCEDURE DIVISION.
FIRST-PARAGRAPH.
   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

Migrates database of COBOL’s application to MSSQLServer database
Convert COBOL’s programs to MSSQLServer procedure

CREATE PROCEDURE DemoId()  AS 
       BEGIN
          PRINT ‘FIRST DEMO’
       END;

Convert WORKING-STORAGE section with declaration variables and records to MSSQLServer DECLARE

WORKING-STORAGE SECTION.
    01 MY_STRING_1    PIC X(20).
    01 MY_STRING_2    PIC X(30).
    01 MY_NUMBER    PIC 9(2) VALUE 1.

To:

DECLARE
    @MY_STRING_1 VARCHAR(20),
    @MY_STRING_2 VARCHAR(20),
    @MY_NUMBER    INT 
SET @MY_NUMBER=1

Convert COBOL records to MSSQLServer CLR user-defined type

01 MY_DATA_RECORD.
    03 MY_NAME        PIC X(20).
    03 MY_ADDRESS  PIC X(40).
    03 MY_ID               PIC 9(2).

To:

CREATE TYPE MY_DATA_RECORD AS TABLE 
            (MY_NAME        VARCHAR(20),
          MY_ADDRESS    VARCHAR(40),  
                 MY_ID INT )
    GO

Convert COBOL MOVE TO/COMPUTE statements to SET assignment statements

MOVE 5 TO MY_NUMBER.

To:

SET @MY_NUMBER=5

Convert 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.
Convert COBOL control structures to MSSQLServer control statements

IF condition
ELSE
END IF

To:

IF condition
ELSE
END IF;

PERFORN UNTIL condition
COBOL statements
END-PERFORM

To:

WHILE condition
          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)

EXEC SQL
    SELECT cur_date 
    FROM val_date
    WHERE cur_date < CURRENT
 END-EXEC.

To:

SELECT cur_date 
    FROM val_date
    WHERE cur_date < GetDate();

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

Why SQLWays

SQLWays 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 SQLWays tool even a more attractive instrument for this project type. SQLWays is also a very flexible conversion tool. Any migration direction can be developed further. It can provide conversion in the shortest terms.

Assessment

Assessment helps estimate the efforts and cost of a migration. For detailed process of assessment please refer to following link:

COBOL Migration Assessment

Please complete the questionnaire to initiate collaboration discussions for your project or get some rough estimation:

COBOL Application Migration Questionnaire (Excel, 20Kb)

Ispirer offers comprehensive engagement process for your application conversion project. For the detailed information please go to Application Migration Engagement Model page.

If you are interested in these services, please contact us for more information.