Microsoft SQL Server Transact-SQL to Java

Ispirer MnMTK is the application migration tool, which supports SQL Server T-SQL to Java conversion.

Why Ispirer MnMTK?

We develop our conversion tool Ispirer MnMTK using a customer-oriented approach in order to meet all your project requirements. Ispirer MnMTK is highly customizable and can be extended in a short time according to your project needs. Such customizations allow to achieve up to 99% of automation of SQL Server to Java migration. You can choose either a tool license or our migration services to convert your Microsoft SQL Server T-SQL to Java.

Our main advantages:

• High quality and experienced technical support: our technical team has a tremendous experience in migration projects of different levels of complexity. We will help you to migrate from Delphi to C# quickly and easily.
• 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.

Conversion Features

During migration from one SQL Server procedure Ispirer MnMTK generates one Java class that contains all the business logic that was implemented inside the procedure.

For example:

Source SQL Server procedure:

 
    CREATE PROCEDURE sp_set_sel
AS
DECLARE @sTemp VARCHAR(30)
DECLARE @sColType VARCHAR(30)
DECLARE @sString1 VARCHAR(30)
DECLARE @sString2 VARCHAR(30)
      SET @sTemp = (SELECT 
          CASE @sColType
            WHEN 'smallint' THEN @sString1
            WHEN 'bigint' THEN @sString1
            WHEN 'tinyint' THEN @sString1
            ELSE @sString2
          END
      )
 

Java code:

 
    import java.util.*;
public class sp_set_sel
{
   public static void spsp_set_sel() throws Exception
   {
      try
      {
         String sTemp = NULL;
         String sColType = NULL;
         String sString1 = NULL;
         String sString2 = NULL;
         sTemp =(sColType.equals("smallint")) 
    ?sString1:(sColType.equals("bigint")) 
    ?sString1:(sColType.equals("tinyint")) 
    ?sString1: sString2;
      }
      catch(Exception e)
      {
         e.printStackTrace();
         throw e;
      }
      finally
      {
      }
   }
}
 

• All the DML statements are moved to PreparedStatements.
  
• Types of the variables are migrated to appropriate types in Java.
  
• Handles Open cursors in Java classes.
  

You are welcome to contact us for more information.