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;
    And
    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:

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.

 
Watch SQLWays Online Presentation
Request a SQLWays Live Presentation
Download Free SQLWays Express Version
Download Free SQLWays Demo Version
Request a Quote for Ispirer Tools or Services
SQLWays for SQL Server
SQL Server Databases

Microsoft SQL Server 2012, 2008, 2005, 2000, 7.0 and 6.5

Microsoft SQL Server Parallel Data Warehouse (PDW) 2012

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...

...

November 25, 2013Ciber, Sweden
Oracle to Microsoft SQL Server Migration
(including PowerBuilder migration)

"Ciber develops system for parking permits to the major cities in Sweden.
In 2012, when the second largest city in...

...

Case Studies
September 24, 2014Progress 4GL to Java, Progress to Oracle Migration, Belgium

A huge provider of solutions in travel sector, whose numerous team operates all over the world, asked Ispirer to perform a complex migration. His business is dedicated to enhancement of...

...

September 13, 2014Visual Basic to Visual Basic.NET Migration, United States

A consulting company from the United States focusing on enterprise mobile device management and delivering solutions to solve business problems addressed to Ispirer because of the necessity to...

...

Events