This is the MSSQL2MySQL Pro manual. You will find here everything you need to know about this tool.
MSSQL2MySQL Pro is a database application which allows you to easily convert MS SQL databases to MySQL and vice versa, unlike other similar tools, which commonly perform only one-way conversion. MSSQL2MySQL Pro performs Unicode support as well as a large number of useful features. The program is extremely easy to use, it was implemented like a common wizard-like application, so even an inexperienced user will be able to work with it. We doubt that you will have any problems with it, but in any case FAQ page is available for your convenience. Regularly benchmark tests show that MSSQL2MySQL Products obviously stand out from the crowd of similar data conversion tools with its improved general functionality, high speed of conversion and stability of the software.
Features:
- Interactive (GUI) mode / command line mode;
- Saving data into a MySQL Dump, PHP script for export to MySQL database;
- Foreign key (relations) support.
- Shared memory, TCP/IP support.
- MS SQL Server 2000/2005 support.
- 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.
- Automation of the conversion process with task scheduler
- Ability to select ISAM, MYISAM, HEAP, InnoDB or BDB table types when copying data to MySQL or MySQL Dump;
- Unicode Support/Connection character sets support:
LATIN1, LATIN2, LATIN5, LATIN7, ARMSCII8, ASCII, CP1250, CP1251, CP1256, CP1257, CP850, CP852, CP866,
DEC8, GEOSTD8, GREEK, HEBREW, HP8, KEYBCS2, KOI8R, KOI8U, MACCE, MACROMAN, SWE7, UTF8 (unicode charset) - Primary keys and Indexes support
- Advanced customization options:
- partial selection for database objects to be converted.
- database objects (tables, fields, indexes) renaming before conversion.
- detection of possible conversion errors at customization stage. - Sessions support - all your settings can be saved and restored then.
- `ENUM` and `SET` MySQL database types support.
- Skins support.
- Multilanguage Support
- 1-year free upgrades.
Requirements:
- Windows XP/2000/NT (NT only with Internet Explorer 4.01)
- At least 32 MB of RAM
- Necessary privileges to write into database on the target MS SQL/MySQL server.
Important notices:
- Does not convert system (hidden) tables.
- Does not convert view.
Application stages
- Start - how to start.
- Process stages - stages of conversion process.
- Registration - how to register.
- FAQ - if you still have any questions, which were not highlighted in the previous sections, or you are experiencing troubles using the application, please, check the MSSQL2MySQL Pro FAQ page out.