Backup and Restoring from extractdata

Curam out of the box provides a facility to extract all the data from the tables and put it back in. This is a short guide on how to use it as part of a simple backup and restore strategy.

Note: use a proper database backup and restore strategy that comes with your database and not this one on a production system, this is more for ad hoc backups and data retention).

I have tested an earlier version of this approach, this is just a slightly refined version.

Backing up the data

This one is quite simple: build extractdata Done. Your extracted data should be located in build/dataextractor

Restoring the data

Make a copy of the release folder (this is the runtime folder for the runtime installations). Modify the project\config\datamanager_config.xml to have the following blocks:

<target name="restore">
 <entry name="build/dataextractor" type="dmx" base="basedir"/>
</target>

<compositetarget name="restore">
 <subtarget name="tables"/>
 <subtarget name="restore"/>
 <subtarget name="constraints"/>
 <subtarget name="indices"/>
</compositetarget>

Copy over the build/dataextractor folder of the time you want to restore to your runtime folder if it is not there already. Make sure the servers are stopped and nothing else is connecting to the database, otherwise you may end up with a deadlock situation. Do build database -Dprm.target=restore and cross your fingers. Start the server. If all goes well your data is restored.