Easily migrate data from one or more Ms SQL Server tables to the specified schema in MySQL in a short time, using this reliable tool.
- MsSqlToMysql
- Version : 2.3 Release 1 Build 170614
- License :Trial
- OS :Windows All
- Publisher :Withdata Software
MsSqlToMysql Description
MsSqlToMysql provides you with a simple way to migrate large amounts of data from Microsoft SQL Server schemas to MySQL tables. The program features a straightforward interface that allows you to quickly setup the data migration parameters, such as the source schema, the destination and additional options.
It offers several methods in which the transfer can be configured, suitable for a large range of users. For instance, you can manually configure the process, by establishing the parameters in the program’s main window. Advanced users can create an SQL query to define the source table or to configure the entire task.
The program also features a wizard function that can help even beginners operate the transfer in a simple and quick manner. It requires you to connect to both Microsoft SQL Server and MySQL, either to a localhost or a remote server. You need to enter the host, port and authentication details to establish the connection.
SSH tunneling is also supported for the MySQL connection; you may enter the required details and save the configuration so that you may easily connect to the databases at a later time. Once connected to both database managers, MsSqlToMysql requires that you specify the source schema and table, as well as the destination.
The program can display the contents of the selected table, allowing you to select the fields to be included/excluded from the transfer. Alternatively, you can choose the multi-table transfer option, in case you wish to migrate a larger segment of the database.
MsSqlToMysql allows you to import the selected data in the MySQL table by appending the existing fields, replacing or updating them. If none of these options are suitable, you can instantly create a new table in the destination schema. The program allows you to preview the result and watch the transfer in progress.
System requirements
- MS SQL Server database
- MySQL Server database
Limitations in the unregistered version
- 30 days trial
- Nag screen