THIS SITE USES COOKIES: By continuing to browse this site, you give your consent for cookies to be used.
For more details, please read our Privacy Policy and Cookies Policy.

Automated and Customizable
Database and Application
Migration and Modernization

VB.NET Embedded SQL Migration

Ispirer MnMTK can become your one-stop migration solution when it comes to VB.NET embedded SQL conversion. Ispirer MnMTK embedded SQL migration tool lets you into the world of fast highly automated migration. With SQLWays you can easily convert embedded SQL statements and embedded SQL queries. Ispirer MnMTK conversion software is constantly upgraded giving our prospective clients a unique opportunity to cut down on costs and timings using our tailor-made embedded SQL conversion solution.

Conversion features:

Ispirer MnMTK tool automatically detects Dynamic SQL queries, parses them and converts to the chosen direction. Beyond that Ispirer MnMTK tool converts Data Type and Imports to the chosen API if required.

The following example shows the conversion from VB.NET Class with Sybase Adaptive Server Enterprise Dynamic SQL to Class with MySQL Dynamic SQL.

Source code for VB.NET Class includes Sybase ASE Dynamic SQL:

  1. Imports System.Data.SqlClient
  2.  
  3. Public Class InsertClassifieds
  4. Function ApproveClassified()
  5. Dim sql, value As String
  6. Dim cmd As SqlCommand
  7. Dim con As SqlConnection
  8. Dim dr As SqlDataReader
  9.  
  10. sql = "update tbl1 set col1='Y' ,
  11. col2=getdate() where col3 in (" & value & ")"
  12. con = New SqlConnection
  13. (ConfigurationSettings.AppSettings("ConnectionString"))
  14. con.Open()
  15. cmd = New SqlCommand(sql, con)
  16. dr = cmd.ExecuteReader
  17. cmd.Dispose()
  18. dr.Close()
  19. con.Dispose()
  20. con.Close()
  21. End Function
  22. End Class

Converted Class includes MySQL Dynamic SQL query and MySQL API:

  1. Imports MySql.Data.MySqlClient
  2.  
  3. Public Class InsertClassifieds
  4. Function ApproveClassified()
  5. Dim sql, value As String
  6. Dim cmd As MySqlCommand
  7. Dim con As MySqlConnection
  8. Dim dr As MySqlDataReader
  9.  
  10. sql = "update tbl1 set col1 = 'Y',
  11. col2 = CURRENT_TIMESTAMP where col3 in(" & value & ")"
  12. con = New MySqlConnection
  13. (ConfigurationSettings.AppSettings("ConnectionString"))
  14. con.Open()
  15. cmd = New MySqlCommand(sql, con)
  16. dr = cmd.ExecuteReader
  17. cmd.Dispose()
  18. dr.Close()
  19. con.Dispose()
  20. con.Close()
  21. End Function
  22. End Class

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.

 
.NET Versions

Microsoft .NET 4.6.1 and earlier

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, Visual Basic 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

Now the developers know your tool works fine…
Thanks for your assistance and we take into account Ispirer for this migration or any other we have to do in the future.

Read more
Industry Events