JCOGS Channel Data Migration Utility

An up-to-date and easy to use utility to migrate ‘legacy’ data field storage from the exp_channel_data table to the more modern ‘one-table-per-field’ method in use since EE4.

JCOGS Channel Data Migration Utility is a simple to use Control Panel utility for EE6 and EE7 for migrating legacy EE field data storage to the new multi-table format introduced with EE4.

What does it do?

• Lists all the ‘legacy’ fields within your site
  EE can use a mix of ‘legacy’ and modern field data storage within a site. For ‘legacy’ fields, the field data is stored as columns within the `exp_channel_data` table within your EE database. Data for fields using the modern storage approach are saved each in their own data table - e.g. the data for the field with ID 7 would be saved in the `exp_channel_data_field_7` table.
• Selectively migrates field types to the new format
  When the utility is opened it creates an inventory of the ‘legacy’ fields found within your site, and displays a list of the field types found - along with a count of the legacy fields found for each type. You can then select one or more of these field types and have a chance to preview the fields to be migrated. If you are happy with your choices, the utility will then migrate the data associated with these fields to the new data storage format.
• Maintains your exp_channel_data table as it goes
  As fields are migrated, the utility also removes any field indexes in the channel_data table associated with the fields migrated, and optimises the table to minimise the data storage requirements of the updated table.

Why choose JCOGS Channel Data Migration Utility?

• It is up to date!
  JCOGS Channel Data Migration Utility is inspired by an original data migration utility developed by EllisLabs. That original utility has no user interface, and is not reliable on EE7. The JCOGS Channel Data Migration Utility is built using the latest EE add-on methods, is compatible with php8, and is both easier to use and more poweful.

Requirements

JCOGS Image has been tested and is supported for use on EE6 and EE7 systems. It requires the server hosting the EE installtion to be running php 8.1 (or better).

Fully supported, ongoing development…

If you have features that you would like to see included in a future version of JCOGS Channel Data Migration Utility get in touch! You can contact JCOGS Support via the JCOGS.net web site or via the EE Slack

Currently in the development pipeline:

• Documentation … !
• Individual field migration as an option
• Improved layout for sites with many legacy field types