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

Progress 4GL to Microsoft SQL Server T-SQL Migration

SQL Server

Ispirer MnMTK is the application migration tool, which supports Progress 4GL to Microsoft SQL Server conversion of any complexity.


Progress 4GL to Microsoft SQL Server T-SQL Migration Overview

We develop our conversion tool using a customer-oriented approach so as we do our best in order to satisfy all your project requirements. Our technical experts have great experience in application migrations and always find innovative solutions even to the most complicated migrations from Progress 4GL to C#.

Ispirer MnMTK allows to convert the following:

  • Progress tables/view/sequences to Microsoft SQL Server T-SQL tables/views/sequences
  • Progress 4GL triggers to Microsoft SQL Server T-SQL triggers/procedures
  • Progress 4GL Procedure Files (*.p) to Microsoft SQL Server procedures
  • Progress 4GL Include Files (*.i) to Microsoft SQL Server functions
  • Progress ABL reports to Microsoft SQL Server Reports

Why Ispirer MnMTK 2015 for Progress 4GL to Microsoft 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 benefits:

  • High quality and experiences 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 approximative cost of your migration. In order to facilitate the process, you're welcome to fill in and send back to us our:

Live Presentation

Ispirer Migration Solution

Progress 4GL to MS SQL Server

Request

Request a Quote

Ispirer Migration Solution

Progress 4GL to MS SQL Server

Service Toolkit

Conversion Features

Migrate Progress databases to Microsoft SQL Server T/SQL databases

  • Converts Progress tables/view/sequences to Microsoft SQL Server T-SQL tables/views/sequences

For example,

Progress 4GL:

  1.  
  2. ADD TABLE "TB_DATATYPES"
  3. AREA "Schema Area"
  4. DUMP-NAME "tb_datat"
  5. ADD FIELD "c1" OF "TB_DATATYPES" AS CHARACTER
  6. FORMAT "X(8)"
  7. INITIAL ""
  8. POSITION 2
  9. SQL-WIDTH 16
  10. ORDER 10
  11. ADD FIELD "c4" OF "TB_DATATYPES" AS INTEGER
  12. FORMAT "->,>>>,>>9"
  13. INITIAL "0"
  14. POSITION 5
  15. SQL-WIDTH 4
  16. ORDER 20
  17. ADD FIELD "c5" OF "TB_DATATYPES" AS logical
  18. FORMAT "yes/no"
  19. INITIAL "no"
  20. POSITION 6
  21. SQL-WIDTH 1
  22. ORDER 30
  23. .
  24. PSC
  25. cpstream=ISO8859-1
  26. .
  27. 0000000976
  28.  

Microsoft SQL Server T-SQL :

  1.  
  2. CREATE TABLE TB_DATATYPES
  3. (
  4. c1 CHAR(16) NULL,
  5. c4 INT NULL,
  6. c5 BIT NULL
  7. )
  8.  
  • Converts Progress 4GL triggers to Microsoft SQL Server T-SQL triggers/procedures

Progress 4GL:

  1.  
  2. TRIGGER PROCEDURE FOR DELETE OF gsinvhd.
  3. FIND distribution
  4. WHERE distribution.company = gsinvhd.company NO-LOCK NO-ERROR.
  5.  

Microsoft SQL Server T-SQL:

  1.  
  2. CREATE TRIGGER SWT_Delete_gsinvhd
  3. ON gsinvhd
  4. AFTER DELETE
  5. AS
  6. DECLARE @distribution_company VARCHAR(255)
  7. SELECT @distribution_company = company FROM distribution
  8. WHERE distribution.company = gsinvhd.company
  9.  

Convert Progress 4GL code to Microsoft SQL Server T-SQL code


Convert Progress 4GL code to Microsoft SQL Server T/SQL code

  • Converts Progress 4GL Procedure Files (*.p) to Microsoft SQL Server procedures

Progress 4GL:

  1.  
  2. PROCEDURE generate-DATA :
  3. DEFINE VARIABLE i AS INTEGER NO-UNDO.
  4. DEFINE VARIABLE gc-company AS CHARACTER NO-UNDO.
  5. FIND company WHERE company.company = gc-company NO-LOCK NO-ERROR.
  6.  
  7. find budget WHERE budget.company = gc-company no-LOCK no-error.
  8. Do while avail budget:
  9. Do i = 0 TO 5:
  10. find budget-analysis
  11. WHERE budget-analysis.user-id = company.gc-user-id AND
  12. budget-analysis.company = gc-company AND
  13. budget-analysis.pc-center = "ALL" AND
  14. budget-analysis.acct-period = i
  15. no-error.
  16. END.
  17. END.
  18. END PROCEDURE.
  19.  

Microsoft SQL Server T-SQL:

  1.  
  2. CREATE PROCEDURE [generate-DATA] AS
  3. BEGIN
  4. DECLARE @company_company VARCHAR(255)
  5. DECLARE @company_numperiods VARCHAR(255)
  6. DECLARE @company_gcuserid INT
  7. DECLARE @budget_company VARCHAR(255)
  8. DECLARE @i INT
  9. DECLARE @gccompany VARCHAR(4000)
  10. SELECT @company_company = company,
  11. @company_numperiods = [num-periods],
  12. @company_gcuserid = [gc-user-id]
  13. FROM company WHERE company.company = @gccompany
  14. SELECT @budget_company = company
  15. FROM budget WHERE budget.company = @gccompany
  16. while EXISTS(SELECT * FROM budget)
  17. BEGIN
  18. SET @i = 0
  19. while @i <= 5
  20. BEGIN
  21. DECLARE @budgetanalysis_userid INT
  22. DECLARE @budgetanalysis_company VARCHAR(255)
  23. DECLARE @budgetanalysis_pccenter VARCHAR(255)
  24. DECLARE @budgetanalysis_acctperiod VARCHAR(255)
  25. SELECT @budgetanalysis_userid = [user-id],
  26. @budgetanalysis_company = company,
  27. @budgetanalysis_pccenter = [pc-center],
  28. @budgetanalysis_acctperiod = [acct-period]
  29. FROM [budget-analysis]
  30. WHERE [budget-analysis].[user-id] = company.[gc-user-id] AND
  31. [budget-analysis].company = @gccompany AND
  32. [budget-analysis].[pc-center] = 'ALL' AND
  33. [budget-analysis].[acct-period] = @i
  34. SET @i = @i+1
  35. END
  36. END
  37. END
  38.  
  • Converts Progress 4GL Include Files (*.i) to Microsoft SQL Server functions
  • Converts Progress ABL reports to Microsoft SQL Server Reports

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