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

Visual Basic Embedded SQL Conversion

Ispirer MnMTK database and application migration tool is a cost effective product that can cater unique business requirements. Ispirer MnMTK offers you to convert embedded SQL statements and embedded SQL queries in Visual Basic. Automated Visual Basic embedded SQL conversion is a step to cutting down on expenses for manual conversion. Our flexible tool is constantly evolving. We place our greatest stress on helping our customers to run a smooth embedded SQL migration and accomplish a wide variety of tasks.

Conversion features:

SQLWays tool automatically detects parses and converts Dynamic SQL queries to the chosen direction.

The following example shows the conversion from VB Class including Informix Dynamic SQL to Class including a MSSQL Server Dynamic SQL query using ADO components:

Source VB Class includes Informix Dynamic SQL:

  1. VERSION 1.0 CLASS
  2.  
  3. ' private properties
  4. Private m_objDB As ADODB.Connection
  5.  
  6. Public Function GetRecordset() As ADODB.Recordset
  7. Dim objRS As ADODB.Recordset
  8. Dim strSQL As String
  9.  
  10. 'Get the ID of the row just entered
  11. objRS = New ADODB.Recordset
  12.  
  13. strSQL = "SELECT TO_DATE(s,'%B %d %Y') FROM tbl1"
  14. objRS.Open(strSQL, m_objDB)
  15.  
  16. End Function

The converted Class includes MSSQL Server Dynamic SQL query:

  1. VERSION 1.0 CLASS
  2.  
  3. ' private properties
  4. Private m_objDB As ADODB.Connection
  5.  
  6. Public Function GetRecordset() As ADODB.Recordset
  7.  
  8. Dim objRS As ADODB.Recordset
  9. Dim strSQL As String
  10.  
  11. 'Get the ID of the row just entered
  12. objRS = New ADODB.Recordset
  13.  
  14. strSQL = "SELECT CONVERT(DATETIME,s,100) FROM tbl1"
  15. objRS.Open(strSQL, m_objDB)
  16.  
  17. End Function

Why Ispirer MnMTK

Ispirer MnMTK migration tool is a flexible customizable solution for various embedded SQL conversion tasks. High level of automation guarantees fast and effective migration of embedded SQL and API from an application.


You are welcome to contact us for more information.

 
Testimonials
November 25, 2013Ciber, Sweden
Oracle to Microsoft SQL Server Migration
(including PowerBuilder migration)

"Ciber develops system for parking permits to the major cities in Sweden.
In 2012, when the second largest city in...

...

August 21, 2014TouchStone Systems, Inc., United States
Sybase ASA to Microsoft SQL Server Migration
(including embedded SQL migration in PowerBuilder)

"To whom it may concern,

Being a leading provider in reverse logistics solutions, we continue to...

...

Case Studies
August 24, 2014PostgreSQL to Oracle Migration, United States (including embedded SQL migration in Java)

The client was a U.S.-based, non-profit organization working within the education sector, striving to ensure equal rights of students in low-income groups across the United States. This was...

...

September 11, 2014Informix to SQL Server Migration, United States (including embedded SQL migration in PowerBuilder, VB to C#, ASP to ASP.NET)

A U.S.-based renowned lessor of trailers requested the services of Ispirer to perform a major migration.

...

Feedback

I just want to touch base with you to let you know that the tool is doing great work so far.

Read more
Industry Events