Migrating to the new rules schema
Use the migrate script to migrate the rules tables and other required database objects from the existing rules schema to the new rules schema. To minimize the time required, run the migration scripts from the same data center as the database server.
- Use a text editor to edit the
migrateSystem.properties
file in the scripts directory of your distribution image:Pega-image\scripts\migrateSystem.properties
- Configure the source properties.
# Connection Information pega.source.jdbc.driver.jar=full path/DRIVER.jar pega.source.jdbc.driver.class=database driver class pega.source.database.type=database vendor type pega.source.jdbc.url=URL of database pega.source.jdbc.username=Deployment user name pega.source.jdbc.password=password pega.source.rules.schema=existing rules schema pega.source.data.schema=existing data schema
- Configure the target properties.
pega.target.jdbc.driver.jar=full path/DRIVER.JAR pega.target.jdbc.driver.class=database driver class pega.target.database.type=database vendor type pega.target.jdbc.url=database URL pega.target.jdbc.username=Deployment user name pega.target.jdbc.password=password pega.target.rules.schema=new rules schema pega.target.data.schema=temporary data schema
- Configure the bulkmover
directory.
pega.bulkmover.directory=full path to output directory
- Configure a temporary
directory:
pega.migrate.temp.directory=full path to temporary directory
- Configure the operations to be performed by the utility as shown below:
pega.clone.generate.xml=true pega.clone.create.ddl=true pega.clone.apply.ddl=true pega.bulkmover.unload.db=true pega.bulkmover.load.db=true pega.rules.objects.generate=false pega.rule.objects.apply=false
- Save the properties file.
- Open a command prompt, and navigate to the scripts directory.
- Type
migrate.bat
(for Windows) or./migrate.sh
(for Linux) to run the script.
Pega Platform writes command-line output to a file in the
Pega-image\scripts\logs
directory.
Previous topic For High Availability systems: Preparing the cluster for patching Next topic Patch methods for the migrated rules schema