THIS SITE USES COOKIES: By continuing to browse this site, you give your consent for cookies to be used.
For more details, please read our Privacy Policy and Cookies Policy.

Automated and Customizable
Database and Application
Migration and Modernization

Informix 4GL to Microsoft SQL Server T-SQL Migration

SQL Server

Migrate from Informix 4GL to Microsoft SQL Server T-SQL with the help of our Ispirer Migration and Modernization Toolkit! It supports Informix 4GL to Microsoft SQL Server T-SQL conversion of any complexity and can be easily customized according to the particular requirements of any migration project.

Why Ispirer MnMTK 2017 for Informix 4GL to MS SQL Server T-SQL Conversion?

The main purpose of Ispirer Systems is to carry out a high-grade and top-of-the-line database migration. We personalize our migration tool Ispirer MnMTK in such a way that a customized version can fully satisfy a client's business requirements.

Our main advantages:

  • High quality and experience technical support: our technical team has a tremendous experience in migration projects of different levels of complexity.
  • 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.
  • Flexible pricing: we can offer you a wide range of options, among which you will definitely find the one which suits you;
  • Optimized Conversion: after the conversion you get an intelligent and maintainable code, without using any Ispirer's middleware.

Assessment Process

The assessment of your migration project could definitely help to weigh up efforts and the approximate cost of your migration. In order to facilitate the process, you're welcome to fill in our:

Live Presentation

Ispirer Migration Solution

Informix 4GL to MS SQL Server


Request a Quote

Ispirer Migration Solution

Informix 4GL to MS SQL Server

Service Toolkit

Conversion Features

Informix database to Microsoft SQL Server database:

  • Tables and Data
    • Converts columns definitions - data types, default values, NOT NULL constraints
    • Converts integrity constraints - primary and foreign keys, unique and check constraints
    • Converts comments
    • Resolves reserved words and identifiers conflicts
    • Transfers data
  • Indexes and Views
  • Stored Procedures, Functions and Triggers
    • Converts overloaded procedures and functions
    • Converts global variables
    • Converts Informix OUTER JOIN syntax
    • Converts exceptions processing
    • Converts dynamic SQL

Informix 4GL code to Microsoft T-SQL Conversion

  • Converts Informix 4GL functions (*.4gl) to T-SQL functions/procedures (*.sql)
  • Informix 4GL:

    2. FUNCTION sample_func(s_char)
    3. #-------------------#
    4. define
    5. s_char CHAR(100),
    6. i SMALLINT,
    7. j SMALLINT,
    8. r_char CHAR(100)
    10. let r_char = " "
    12. FOR i = 1 TO 100
    13. IF (s_char[i,i] = " ") THEN
    14. continue FOR
    15. ELSE
    16. let r_char = s_char[i,100]
    17. exit FOR
    18. END IF
    19. END FOR
    21. RETURN r_char

    Microsoft SQL Server T-SQL:

    2. FUNCTION sample_func(@s_char CHAR(2000))
    3. ---------------------#
    4. RETURNS CHAR(2000)
    5. BEGIN
    6. DECLARE @i INT = 0
    7. DECLARE @j INT = 0
    8. DECLARE @r_char CHAR(100) = ' '
    10. SET @r_char = SUBSTRB(' ',1,100)
    11. SET @SWR_i = 1
    12. while (@SWR_i <= 100)
    13. BEGIN
    14. SET @i = @SWR_i
    15. IF(SUBSTRB(@s_char,@i,1))
    16. continue
    17. ELSE
    18. BEGIN
    19. SET @r_char = SUBSTRB(SUBSTRB(@s_char,@i,101 -@i),1,100)
    20. BREAK
    21. END
    22. SET @SWR_i = @SWR_i+1
    23. END
    24. RETURN @r_char
    25. END
  • Converts comments:

  • Single line comments

    Informix 4GL:


    Microsoft SQL Server T-SQL:

    2. --Comment

    Multiline comments

    Informix 4GL:


    Microsoft SQL Server T-SQL:

    2. /*
    4. */
  • Convert data types
  • Informix 4GL type Microsoft T-SQL data type
    char(length) CHAR(length)
    smallint INT
    integer INT
    date DATETIME
    decimal(n,m) DECIMAL(n,m)

  • Converts records to table type variables
  • Informix 4GL:

    2. define c0 record LIKE ctl_f0.*

    Microsoft SQL Server T-SQL:

    2. DECLARE @c0 TABLE (ctl_f0_id INT, ctl_f0_name VARCHAR(100),
    3. ctl_f0_description VARCHAR(1000))
  • Converts built-in functions, expressions and predicates
  • Informix 4GL type Microsoft T-SQL data type
    Ascii function let a = ascii 223 SET a = CHAR(223)
    Clipped function let a = b clipped SET a = RTRIM(b)
    Date function let a = date(b) SET a = CONVERT(DATETIME, b)
    Day function let a = day(b) SET a = DATEPART(DAY, b)
    Mdy function let a = mdy(b,c,d) SET a = CONVERT(DATETIME,STR(b) + '-' + STR(c) + '-' + STR(d))
    Month function let a = month(b) SET a = month(b)
    Upshift function let a = upshift(b) SET a = UPPER(b)
    Using function let a = b using "######&" SET a = STR(b,[’9999990’])
    Year function let a = year(b) SET a = year(b)
    Concat expression let a = b, “cd”,d SET a = b + [“cd”] + d
    Mod expression let a = b mod 2 SET a = b%2
    Substring expression let a = b[2,2] SET a = substr(b,2,1)
    True/False expression let a = true let
    a = false
    SET a = true
    SET a = false
    Matches predicate if (n not matches "[0123456789]") then if (not regexp_like(n,'[0123456789]')) then

  • Converts statements of business logic
  • For example,

    For range loop

    Informix 4GL:

    2. FOR i = 1 TO 10
    3. END FOR

    Microsoft SQL Server T-SQL:

    2. SET @i = 1
    3. while (@i <= 10)
    4. BEGIN
    5. SET @i = @i+1
    6. END

    Case statement

    Informix 4GL:

    2. CASE a
    3. WHEN 1
    4. WHEN 2
    5. otherwise
    6. END CASE

    Microsoft SQL Server T-SQL:

    2. IF @a = 1
    3. ELSE IF @a = 2
    4. ELSE IF
    5. ELSE
    6. END

    Declare cursor

    Informix 4GL:

    2. DECLARE cur_n0 cursor FOR
    3. SELECT n0_ch FROM nkin_a
    4. WHERE (n0_kau_no = s_kau_no)
    5. AND (n0_cd = s_cd)

    Microsoft SQL Server T-SQL:

    2. DECLARE CUR_N0 cursor FOR SELECT n0_ch FROM nkin_a
    3. WHERE (n0_kau_no = s_kau_no)
    4. AND (n0_cd = s_cd)

You can also reach us via Contacts page.

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.



Everything went very well, thank you! We did convert everything that we needed without a problem! It was perfect and we have the output we need. Thank you!

Read more
Industry Events