Data Migration Scripts Generation

For the shared all or store persistence configurations, you can migrate an existing database data from legacy ID format to new ID format by using the migration scripts.

To generate the migration and supportive SQL scripts, connect to an existing database used in a project by using the Backingstore Deployment utility in TIBCO BusinessEvents Studio. The supported databases are Oracle, MS SQL, MySQL and PostgreSQL.

You can also generate these migration scripts for a project using the be-storedeploy utility from the CLI.

For a detailed process, see Generating Deployment Scripts for a Store

When ID migration script is executed on the existing legacy ID database, it copies all the data to the new ID format by setting the extId as the primary key for all entities in database tables. The script adds a unique value wherever extId value is null for the rows in the existing database tables and also maintains all the reference and containment relationships of the data.