DocumentationExperience Cloud KCS

Migrating MySQL databases during AEM Forms JEE upgrade to LTS SP2

Last update: August 26, 2026

This article explains the recommended process for migrating a MySQL database when upgrading from AEM Forms JEE SP21 or SP25 to LTS SP2, ensuring compatibility and data integrity.

Description description

Environment

  • Adobe Experience Manager Forms on JEE 6.5.23.0 source environment
  • Adobe Experience Manager 6.5 LTS Forms SP2 target environment
  • JBoss EAP deployment
  • MySQL database
  • A supported operating system, JDK, MySQL version, JDBC driver, and JBoss EAP version

Issue/Symptoms

  • Organizations upgrading from AEM Forms JEE SP21 or SP25 to LTS SP2 need to migrate their MySQL database.
  • A direct database dump and restore is not sufficient, as it doesn’t upgrade the AEM Forms schema or migrate all required data components.

Resolution resolution

Follow the steps below to resolve the issue.

  1. Upgrade your existing AEM Forms JEE environment (SP21 or SP25) to the 6.5.23 Full Installer baseline.
  2. Prepare the target platform and MySQL environment for AEM Forms JEE LTS SP2, ensuring compatibility with the supported MySQL version for LTS SP2.
  3. Take a logical backup (SQL dump) of your MySQL database from the upgraded 6.5.23 environment.
  4. Restore the database backup into the target MySQL environment.
  5. Configure the target AEM Forms JEE LTS SP2 environment with the correct JBoss datasource, JDBC driver, database credentials, and other required platform configurations.
  6. Run Configuration Manager in upgrade mode and select ‘Initialize AEM Forms Database’ to perform the necessary schema upgrades.
  7. Migrate or restore GDS and CRX data as applicable to the new environment.
  8. Validate the migration in a cloned or parallel environment before production cutover by testing key Forms operations such as login, workflow execution, PDF generation, and document retrieval.
  9. Before starting migration, take full backups of both the database and the environment, and retain the old environment for rollback if issues are encountered.
recommendation-more-help
experience-cloud-kcs-help-kbarticles