In this section we will discuss how to convert a database. There are a few kind of conversion you can do:

• Derby to H2
• Derby to MySQL
• H2 to MySQL

You can also use the NoSQL module and migrate the historical values from a Derby, H2 or MySQL database. This also works to migrate historical values from an older Mango M2M database as way of retaining all data when migrating from Mango M2M to Mango Automation.

You will find the database conversion settings in the env.properties file

# Database settings for conversion. If the db.* settings point to a new database instance, and the convert type setting
# is set, Mango Automation will attempt to convert from the convert.db.* settings to the db.* settings
# Note that database conversions should not be performed in the same step as an upgrade. First upgrade, then convert.
convert.db.type=
convert.db.url=${convert.db.url}
convert.db.username=${convert.db.username}
convert.db.password=${convert.db.password}

The convert.db.type= (derby, h2, mysql) is the database you are converting from and the url, username and passwords are for that database.

This database will be converted to the main database type set in the env.properties file.