ASP 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 ASP (Active Server Pages). Automated ASP 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.

Active Server Pages is a server-side script engine for dynamically generated Web Pages. ASP can use VBScript with Dynamic SQL in code. Embedded SQL in ASP is presented as Dynamic SQL string.

Conversion features:

ASP is HTML pages with Active Scripting engine. Ispirer MnMTK migration tool automatically detects and converts Dynamic SQL from HTML pages.

The following example shows a conversion for ASP with VBScript which contains Dynamic SQL query.

Source ASP includes MySQL Dynamic SQL string variable:

<%@ Language=VBScript %><%Dim sql, rs, con%><%sql="select DATE_FORMAT(CURRENT_DATE, '%m') from t"rs.Open sql,con%>

String variable is converted to Oracle Dynamic SQL:

<%@ Language=VBScript %><%Dim sql, rs, con%><%sql="select DATE_FORMAT(CAST(CONVERT(VARCHAR,GetDate(),10) as datetime),'%m') from t"rs.Open sql,con%>

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.

If you are interested in these services, please contact us for more information.