Convert MySQL to SQL Server

Convert your databases quickly and easily. Power-users will find unmatched customizations and features.

30 Day Money-Back Guarantee!

Full Convert
MySQL to SQL Server conversion using Full Convert

Full Convert is super-easy to use and will migrate your MySQL database to SQL Server in no time. When you need power, you will find powerful customization features, built-in scheduler, ability to run custom SQL scripts and many other fantastic features. Click here to learn more.

  • 30 Day Money-Back Guarantee
  • 12 Months of Free Upgrades and Technical Support
  • Instant Delivery
Download free trial Buy Now

Getting started with MySQL to SQL Server migration

Purpose of this tutorial is to show you basic use of Full Convert in migrating MySQL to SQL Server. To learn about advanced features such as built-in scheduler, data type customization, project customization rules, per-table column mapping, logging, options etc., take a look at the Full Convert project page and read all about it.

Let's do your first database conversion. Click on the New database conversion link, or click on the New button on the ribbon above.

Start new project

Project wizard will lead you through everything you need to set up your conversion

There are just 4 screens in our project wizard - and the last one is actually just a confirmation. We wanted to make it super-easy even for non-technical people.

1. Connect to your source MySQL database

We will choose MySQL from the source database engines list. As our MySQL server is on the local machine and we have full privileges, we will simply choose a database from the dropdown menu.

Connection to source MySQL database
2. Connect to your target SQL Server database

From the list of available target database engines, we'll choose SQL Server. Depending on the SQL Server installation, we need to specify the server name, or server\instance name in the Server field. Note: for SQL Server Express, instance is required, like this: servername\SQLEXPRESS We have Windows authentication here, so all we need to do is select our desired database from the drop-down list.

Connections to target SQL Server database
3. Table selection

We will now select tables for conversion. All tables in the right list will be converted from MySQL to SQL Server - please note that you can count rows of tables to easily see where data actually resides. Clicking

Unselect empty moves all empty tables to Do not convert list.

Select your MySQL tables to convert
4. Summary

You have now provided everything needed for conversion to begin.

Simply press the Convert! button to start it.

Alternatively, you can opt to browse your target database instead and postpone conversion. As Full Convert has full-fledged database/data explorer built-in, we will show you all the tables in the target database. You can even open any table and see its contents. You would typically do this immediately after the conversion, but it's handy if you want to set up project and save it without running the conversion right away.

This is beginner's tutorial, so we won't go into details of power-user's options of project customization.

Review your choices before commencing database migration

Conversion progress, while you lean back and enjoy

Full Convert is very fast. We use dedicated native database components instead of relying on translation libraries like ODBC which incur performance hit and often have bugs of their own. Reaching transfer of 20.000 records per second is not uncommon. Of course, that speed can't be reached with slow databases (like Access, for example), when large binary data is in table, or when network lag is an issue.

Database migration progress

Detailed summary to MySQL to SQL Server migration

After MySQL to SQL Server conversion is finished, you will be presented with a summary. If errors occur, you will be able to inspect them in detail, see SQL commands used (if you enabled SQL logging option), as well as save all the logs. Where appropriate, we provide you with suggestions of how to further speed up transfer or avoid certain issues.

By the way, Full Convert handles databases of unlimited size and (as you can see) is incredibly easy to use.

Migration summary

Quickstart tutorial video for you - see how easy it is...

We have prepared a 4-minute tutorial video for you. Of course, we couldn't record hundreds of database conversion scenarios for all source and target databases we support, but even if this video doesn't show your desired databases, you will see how our application is used and how quickly and easily you can go from MySQL to SQL Server using Full Convert.

After looking at the video, we invite you to download trial version or purchase full version and start converting your database in minutes!

Full Convert
Why wait? Convert your MySQL database to SQL Server right away!

Full Convert is absolutely the best database conversion application on the market. Download our free and fully supported trial or simply go ahead and purchase on our web shop. Download link and license key are sent to your mail within seconds, so you can immediately start doing serious work.

  • 30 Day Money-Back Guarantee
  • 12 Months of Free Upgrades and Technical Support
  • Instant Delivery
Download free trial Buy Now

Clients from 90+ countries love us

While we have many thousands of satisfied clients, let's show you just a few dozen well-known companies and institutions that use our products:

Full Convert clients