Visual Basic Embedded SQL Conversion

SQLWays database and application migration tool is a cost effective product that can cater unique business requirements. SQLWays 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:

VERSION 1.0 CLASS
 
' private properties
Private m_objDB As ADODB.Connection
 
Public Function GetRecordset() As ADODB.Recordset
    Dim objRS As ADODB.Recordset
    Dim strSQL As String
 
    '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)
 
End Function

The converted Class includes MSSQL Server Dynamic SQL query:

VERSION 1.0 CLASS
 
' private properties
Private m_objDB As ADODB.Connection
 
Public Function GetRecordset() As ADODB.Recordset
 
    Dim objRS As ADODB.Recordset
    Dim strSQL As String
 
    '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)
 
End Function

Why SQLWays

SQLWays 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.

To order a demo of SQLWays conversion software please go to request a demo. To find out about our pricing policy go to request a quote. You can also reach us via e-mail at sales@ispirer.com or support@ispirer.com and get a professional answer to any question.