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.

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:

VERSION 1.0CLASS

' private properties

Private m_objDB As ADODB.Connection

PublicFunction GetRecordset()As ADODB.Recordset

Dim objRS As ADODB.Recordset

Dim strSQL AsString

'Get the ID of the row just entered

objRS =New ADODB.Recordset

strSQL ="SELECT TO_DATE(s,'%B %d %Y') FROM tbl1"

objRS.Open(strSQL, m_objDB)

EndFunction

The converted Class includes MSSQL Server Dynamic SQL query:

VERSION 1.0CLASS

' private properties

Private m_objDB As ADODB.Connection

PublicFunction GetRecordset()As ADODB.Recordset

Dim objRS As ADODB.Recordset

Dim strSQL AsString

'Get the ID of the row just entered

objRS =New ADODB.Recordset

strSQL ="SELECT CONVERT(DATETIME,s,100) FROM tbl1"

objRS.Open(strSQL, m_objDB)

EndFunction

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.