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


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.

 
Meet Ispirer MnMTK 2017!
October 4, 2017 Meet Ispirer MnMTK 2017!

We are glad to announce the Release of Ispirer Migration and Modernization Toolkit 2017! We worked in a strong cooperation with our customers to make it more convenient and powerful.


ASP Versions

ASP 1.0; 2.0; 3.0

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 have been able to install the tool, and I must say that it has been one of the best I have found on the Internet. For the moment I’ve learned to manage the tool well.

Read more
Industry Events