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

ADO.NET Applications from SQL Server to MySQL

What is ADO.NET?

ADO.NET is a set of computer software components that programmers can use to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework. Microsoft provides ADO.NET Data Provider for SQL Server (System.Data.SqlClient namespace) to access SQL Server. To access MySQL, you can use MySQL Connector/NET, a native ADO.NET Data Provider for MySQL (MySql.Data.MySqlClient namespace).

Why Ispirer MnMTK?

MnMTK helps you to automatically perform comprehensive assessment and migration of embedded SQL statements (dynamic SQL) as well as ADO.NET provider classes & methods in .NET applications. With MnMTK there is no need extracting SQL statements from application code and convert them separately. The tool completes the whole migration process internally.

Conversion features

SQLWays automates the following migration activities:

  • Changing Connection String
  • Changing ADO.NET namespaces:
    MSSQLServer MySQL
    System.Data.SqlClient MySql.Data.MySqlClient
  • Mapping Basic ADO.NET Classes:
    .NET Framework MSSQLServer MySQL
    Connection SqlConnection MySqlConnection
    Command SqlCommand MySqlCommand
    DataReader SqlDataReader MySqlDataReader
    DataAdapter SqlDataAdapter MySqlDataAdapter
    Parameter SqlParameter MySqlParameter
    Etc.
  • Converting Dynamic SQL language elements and built-in functions with different syntax in SQL Server and MySQL
    For example,

    MSSQLServer
    1. SqlDataAdapter da = new SqlDataAdapter();
    2. da.SelectCommand = new SqlCommand
    3. ("SELECT ISNULL(Itemtypeid,'N/A')
    4. FROM ItemTypeMaster", _conn);

    MySQL
    1. MySqlDataAdapter da = new MySqlDataAdapter();
    2. da.SelectCommand = new MySqlCommand
    3. ("SELECT IFNULL(Itemtypeid,'N/A')
    4. FROM ItemTypeMaster ", _conn);

How to convert?

A detailed description of such migration process can be found at:

Embedded SQL and Database Access API Migration

 

Assessment

The product can be an effective assessment tool for your project. The assessment process is a turn-key solution for estimating efforts and costs of migration. For ADO.NET and Dynamic SQL in .NET applications conversion the assessment can involve the following:

  • Identify source files containing database access code statements
  • Identify lines of code with database related statements
  • Identify SQL statements

MnMTK automates the entire migration of ADO.NET and Dynamic SQL in .NET applications. This allows you to dramatically decrease conversion risks and significantly reduce in-house efforts. Reasonable pricing strategy makes SQLWays even more powerful instrument for such migration type.


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, 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’ve just tested your tool and I’ve really appreciated the high quality of the conversion, the tool is easy and pleasant to use.

Read more
Industry Events