This Add-On helps you migrate your site's database from a Windows environment to Linux (case sensitive). You need this for example if you have developed your site under Windows with the default MySQL configuration with case insensitive table names. But if you want to migrate vice versa, you can also download that script and run it if you’d like. A little something for everyone (although a case insensitive environment will most likely turn your case sensitive tables to all lowercase automatically).
You need this script if you're moving your site from a server that has used MySQL lower case table names to a server where you need case sensitive table names. For example if you're moving your site from a Windows development environment to Linux production environment, you might need this if you have not set the MySQL server's configuration correctly on the Windows development environment.
Get a database exception saying something like this:
mysql error: [1146: Table 'your_database.Packages' doesn't exist]
Then this Add-On might be just for you! This happens if you move your site from a case insensitive environment (e.g. Windows) to a case sensitive environment (e.g. Linux).
You've installed a couple of Add-Ons, maybe uninstalled them or have created your own Add-Ons. By using Database Migration, you will see which tables are not mentioned in any of the available Add-Ons. So you either have to add these to your db.xml file of the Add-On, or if ithe Add-On got deleted, simply delete the mentioned database table(s).
You can find the tools under System & Settings => Backup & Restore => Database Migration. For further instructions, please see the Documentation page.
This Add-On is officially made by Mainio Tech Ltd., for Concrete5 5.4.2 — 220.127.116.11.
This Add-On got ported, with exclusive permission from the above company's CEO (Antti Hukkanen), to Concrete5 5.7.x by Devoda.