Skip to content

DB Converter: MySQL to MS SQL

Older articles

DB Converter converts database scripts between Microsoft SQL Server and MySQL. It’s free and open source, and contributions are welcome. It could be extended to other databases such as Oracle or Sybase.

Features

  • Open source
  • Config-driven: add new functions by updating the config file
  • UI-based tool
  • Tested with WordPress, SuiteCRM and SugarCRM

DB Converter

Configuration

Update the configuration XML to add new functions or keywords. These sections can be changed:

  • DataType
  • BuiltInFunctions
  • LanguageElements
  • Table
  • Exclude_MySQL
  • Exclude_MSSQL

In each node, the key attribute holds the MS SQL command and the value attribute holds its MySQL equivalent. Exclude entries are replaced with blanks during conversion.

DB Converter configuration file

Download

Get the tool and config file from GitHub. No licence is required.

Was this helpful?
All docs