Database migration
Are you ready for 3.0?
Mingle 3.0 will not longer support MySQL database. Mingle will continue to support Postgres and Oracle databases. In order to help our existing customers migrate from MySQL we have some migration options available.
Migrating to Postgres
MySQL to Postgres script
In order to help migrate your existing MySQL 2.3 or 2.3.1 database to Postgres 2.3 or 2.3.1 we have a database migration script available called mingle-dbmigrate-x_x. This tool can be found in <MINGLE_HOME>/tools/mingle-dbmigrate-x_x.zip directory where <MINGLE HOME> is the directory where Mingle 3.0 is installed.
To use this tool, please unzip mingle-dbmigrate-x_x.zip and follow the instructions in <MINGLE_HOME>/tools/mingle-dbmigrate-x_x/README.
If you just wish to migrate your existing projects you may also use the export and import tool described below.
Migrating to Oracle
In order to aid migration to Oracle you may like to use the Mingle's export and import tool.
Export and Import Tool
This tool can be found in <MINGLE_HOME>/tools directory where <MINGLE HOME> is the directory where Mingle is installed.
To use this tool please follow the instructions in the <MINGLE_HOME>/tools/export_import/readme.txt.
As outlined in readme.txt if using this tool to migrate from one database to another you should:
- complete the Mingle installation process using the new database settings in their entirety, including creation of an initial user, before running this tool
- license the new instance
- create any users who are not associated with a project manually, using Mingle, as they will not be imported with the projects
- review the templates after the import has completed to remove any duplicates of the standard templates that may have been installed
The tool can be used to export all projects on any database and therefore, if you wish to easily export all projects for archive purposes this tool can be used.