Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com
Learn how to create Excel dashboards.

SQL to MySQL Converter

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

MSSQL Databases to MySQL Server

Convert MSSQL To MySQL | Developers Site

MSSQL to MySQL is a program to migrate Microsoft MSSQL databases to MySQL server. Depending on your privileges on the target MySQL server you can export MS MSSQL data into new database or overwrite the contents of an existing MySQL database.

MSSQL to MySQL Features

  • All MS MSSQL data types and attributes are supported
  • Works with all versions of Unix and Windows MySQL servers
  • Merges MS MSSQL data into an existing MySQL database
  • Converts individual tables
  • Converts indexes with all necessary attributes
  • Command line support
  • VServer user's option
  • Exports MS MSSQL databases into a dump file
  • Easy-to-use wizard-style interface
  • Full install/uninstall support

MSSQL to MySQL Limitations

  • Works with MS MSSQL 2000 and MS MSSQL 7.0 only
  • Does not convert stored procedures
  • Does not convert foreign keys
  • Does not convert views

MSSQL to MySQL Requirements

  • Windows 2000/XP or Windows NT 4 with Internet Explorer 5 or later or Windows 98/ME or Windows 95 with Internet Explorer 5 or later
  • At least 32 MB of available memory
  • MS MSSQL environment (server or client components of MS MSSQL should be installed on the same machine where you run MSSQL-to-MySQL from)

MSSQL to MySQL VServer user's option

If you are using Virtual Server hosting you probably have no sufficient privileges to create new databases on the target MySQL server. For this case we recommend the following approach:

  1. ask your Virtual Server administrator to create blank database for you
  2. run MSSQL-to-MySQL and select this database as the conversion target
  3. click "Yes" when you will be asked if you'd like to overwrite existing MySQL database

When you complete these steps, the entire contents of the source MS MSSQL database will be imported into the specified MySQL database.

MySQL dump file

MSSQL-to-MySQL allows users to perform deferred conversion and get more control over the process. Following this way, the program stores the contents of the source database into a local dump file instead of moving it to MySQL server directly. The resulting file contains MySQL statements to create all tables and to fill them with the data. You will be able to import this file into existing MySQL database via MySQL client as follows: mysql.exe --host=... --user=... --password=... -vvf {MySQL database name} < {dump file name}

Screen Shots

MS SQL to MySQL - a program to migrate MS SQL databases to MySQL server MS SQL to MySQL - a program to migrate MS SQL databases to MySQL server
MS SQL to MySQL - a program to convert MS SQL databases into MySQL format MS SQL to MySQL - a program to move MS SQL databases to MySQL server
MS SQL to MySQL - a program to migrate MS SQL databases to MySQL server MS SQL to MySQL - a program to convert MS SQL databases into MySQL format

MSSQL to MySQl Converter $49.95  Secure Payment Options

Convert MSSQL To MySQL | Developers Site

order MSSQL-to-MySQL + MySQL-to-MSSQL $73.50 ORDER NOW

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.



Instant Download and Money Back Guarantee on Most Software

Try out: Analyzer XL | Downloader XL | Smart VBA | Trader XL Pro (best value) | ConsoXL | MergeXL | O2OLAP for Excel | MORE>>

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS