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

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

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:

    1.  
    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)
    9.  
    10. let r_char = " "
    11.  
    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
    20.  
    21. RETURN r_char
    22.  
    23. END FUNCTION
    24.  

    Microsoft SQL Server T-SQL:

    1.  
    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) = ' '
    9. DECLARE @SWR_i INT
    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
    26.  
  • Converts comments:

  • Single line comments

    Informix 4GL:

    
    #Comment
    
    

    Microsoft SQL Server T-SQL:

    1.  
    2. --Comment
    3.  

    Multiline comments

    Informix 4GL:

    
    {
    Comments
    }
    
    

    Microsoft SQL Server T-SQL:

    1.  
    2. /*
    3. Comments
    4. */
    5.  
  • 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:

    1.  
    2. define c0 record LIKE ctl_f0.*
    3.  

    Microsoft SQL Server T-SQL:

    1.  
    2. DECLARE @c0 TABLE (ctl_f0_id INT, ctl_f0_name VARCHAR(100),
    3. ctl_f0_description VARCHAR(1000))
    4.  
  • 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:

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

    Microsoft SQL Server T-SQL:

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

    Case statement

    Informix 4GL:

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

    Microsoft SQL Server T-SQL:

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

    Declare cursor

    Informix 4GL:

    1.  
    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)
    6.  

    Microsoft SQL Server T-SQL:

    1.  
    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)
    5.  

You can also reach us via Contacts page.

 
Meet Ispirer MnMTK 2017!
October 4, 2017 Meet Ispirer MnMTK 2017!

We are glad to announce the Release of Ispirer Migration and Modernization Toolkit 2017! We worked in a strong cooperation with our customers to make it more convenient and powerful.


PGDay.IT 2017
September 19, 2017 PGDay.IT 2017

We are happy to announce that Ispirer Systems will support the PGDay.IT 2017 that will be held on October 13th, 2017 in Milan, Italy.


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

It’s been pleasure that I found your tool for migrating Delphi to C#.NET. And I also see that it seamlessly migrates the Delphi features to C#.

Read more
Industry Events