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

...

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

Our Client was a World Leader in Market-Driven Innovation and Science. For more than 200 years, it has brought world-class science and engineering to the global marketplace through innovative...

...

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

Our client was a health insurance company operating for more than 60 years in the United States. It offers wide choice in hospitals and other institutions providing care services.

...

Feedback

Progress to Microsoft SQL Server, Norway
December 15, 2014
Installing and registering the SQLWays Express evaluation worked just fine. I´m doing the evaluation on a Progress 8.3A database using the
Read more

Industry Events