| Need more info? Click here to get it. |
Home |
Pricing starts at $299. For each purchase one year of free upgrades is included, as well as 30 Day Money-Back Guarantee.
Convert SQL Server to MySQL
We will now migrate Microsoft SQL Server database to MySQL in under five minutes.
Purpose of this tutorial is to show you basic use of Full Convert. To learn about features such as built-in scheduler, data type customization, project customization rules, logging etc., take a look at the advanced tutorials.
This tutorial was made when Full Convert was in version 2.2, and the current version is 4.6, so take a look at all the new stuff by going here.
Purpose of this tutorial is to show you basic use of Full Convert. To learn about features such as built-in scheduler, data type customization, project customization rules, logging etc., take a look at the advanced tutorials.
This tutorial was made when Full Convert was in version 2.2, and the current version is 4.6, so take a look at all the new stuff by going here.
Connecting to databases
As we start Full Convert, main form is empty.
Let's create new conversion session. Welcome dialog has "Create new conversion" item for this purpose.
Here we will choose SQL Server database from the list of available source database formats and fill in connection properties. If you use SQL Express or SQL Server 2005, you have to type in the server\instance in Server field. If you use earlier version of SQL Server (for example SQL Server 2000), you can use server name without any instances, even leave it blank if your database resides on localhost. For this purpose, we will select standard Northwind database.
Clicking Next, we need to select our desired target database (as Enterprise version supports multiple targets), or simply fill in connection properties if you are owner of Full Convert Edition.
We will now select tables for conversion. 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.
Clicking "Next" button brings us to the last page in the wizard, the summary. By default, "I want to convert immediately." option is selected. This is what we want. Otherwise, you can also choose to only explore target database at this point (as Full Convert has full-fledged database/data explorer built-in) and simply press "Convert!" button on toolbar when ready.
So, pressing "Convert!" button immediately begins the conversion process.
Conversion
You can cancel conversion process anytime. For smaller databases we are done in few seconds.
After conversion is finished you will be presented with a summary, which you can save. All eventual errors will be shown in a separate tab.
Detailed summary
Owners of Enterprise version can also inspect and save SQL script generated during the conversion. Possible use for this is further manual inspection of data or use of our automated conversion process in any other desirable application.
Navigating the target database
Navigating structure tree shows us what the target database looks like now. You are now free to do further modifications on structure, rename columns or change their type, drop obsolete columns, extract part of a table to new table etc.
