SQL to MySQL Converter
SQL to MySQL Converter is a best program that will convert Microsoft SQL Server Databases to MySQL. Microsoft SQL Server is a relational database server, developed by Microsoft: it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). MySQL is the world’s most used relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. Convert databases from MS SQL to MySQL or from MySQL to MS SQL rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed! Reach the desired result by simply configuring of several options through Wizard interface or in command line mode! SQL to MySQL is also applicable for MySQL database migration to another MySQL database or to another MySQL server. Moreover, SQL to MySQL Converter is quite well for copying MS SQL database to another MS SQL database.
SQL to MySQL Converter Freeware Features
One page interface;
Transfer data directly from one server to another;
Select tables to transfer;
Transfer password protected databases;
Supports both shared security and user-level security;
Optional transfer of indexes;
Optional transfer of records;
Optional transfer of default values in field definitions;
Identifies and transfers auto number field types;
Easy install, uninstall and upgrade;
No need to set up an ODBC connection, the program will handle that for you;
Automation of the conversion process with task planner scheduler;
High speed data conversion. SQL2MySQL speed noticeably exceeds average showing in this category as the program works with direct SQL to MySQL server;
Primary keys and Indexes support ;
Foreign keys (relations) support;
MySQL schemes support.
SQL to MySQL Converter Features (Pro Ver.)
Select fields to transfer;
Create a dump file;
Saving data into a MySQL Dump and PHP script for export to MySQL database;
Interactive (GUI) mode / command line mode;
Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for DBMS internal purposes) with a substitute symbol;
Unicode Support/Connection character sets support:
MULE_INTERNAL, SQL_ASCII, LATIN1, LATIN2, LATIN5, LATIN7, KOI8, ALT, WIN1250, WIN, WIN1256, ISO_8859_7, ISO_8859_8, UNICODE (utf-8);
Advanced customization options:
– partial selection for database objects to be converted;
– database objects (tables, fields, indexes, foreign keys) tuning up before conversion;
– detection of possible conversion errors on customization stage.
Sessions support – all your settings can be saved and restored later;
Data array support;
`GUID` SQL database type support;
`OLE Object` packages support;
Ability to connect to MySQL database servers located on Unix-like and Windows machines;
Full documentation supplied with the software;
Multilanguage Support (English, French, Russian, German, Spanish, Italian, Greek and Danish).
SQL to MySQL Converter System Requirements
Windows 8/Windows 7/Vista/XP/2000/NT (NT only with Internet Explorer 4.01)
At least 64 MB of RAM
Necessary privileges to write into database on the target MySQL server .
SQL Server 97/2000/2005/2008/2010
MySQL 4x/5.X
Using SQL to MySQL Converter
In the first step you are asked to supply the connection settings of the Microsoft SQL Database to convert. If your SQL database requires you to log in you can specify a user name and password.
The destination database and MySQL server connection settings are specified as shown below. You will have the choice of placing the result in a dump file instead of transferring it directly to another MySQL database.
You can specify exactly which tables you want to transfer to the destination database. Just check the box in front of each table name you want to transfer and click next. Select tables to convert (ctrl/shift click).
Check conversion options accordly (create schema, copy data, etc. Additional transfer options can be set in the dialog shown below. Here you can specify if you want to transfer the indexes of the SQL database to MySQL. You can also select not to transfer any records. This will only create the tables in the destination table and leave them empty.
In both SQL and MySQL fields can have default values. When creating the tables in MySQL the program can preserve the default values specified in the SQL field definition. Also auto number properties of a field can be transferred if you check the Auto number properties box.
Press Convert button to start convertion process. The transfer will now run until all the selected tables are transferred. When the transfer is done you will see a small report telling you how much data was transferred.
When conversion is finished, apply constraints and indexes (if any).
The settings of the wizard can be saved in a .ini file.
SQL to MySQL Converter Freeware Screenshot
News about SQL to MySQL Converter
1.0.1 (2012-03-30) SQL to MySQL Converter first release.
Support about SQL to MySQL Converter Freeware
Should there be any queries, please don’t hesitate to contact me by support@converterfreeware.com.
Leave a Reply