EPS Database Migration Tool Read Me
-----------------------------------

You should back up both databases before performing the migration. If you
encounter any problems you should restore from your backups and send the 
error message to support@enterprisedatasafe.net.

You should note that the destination database will have all of it's 
data erased during the migration. After a successful migration the 
destination  database will only contain the data held in the source 
database.

** Pre-requisites **

- You should ensure that the destination databases has been initialised.

- Both the source and destination installations must be using the latest 
version of the EPS (currently 1.57.12). If you do not use the same version 
of the EPS the migration may abort with an error. 

- You should copy the JDBC driver files for both the source and the
destination databases into the directory this file is located in.

- You should ensure that java is in your path before running the 
migration.

** Configuration file **

The migration tool uses a configuration file to determine the source and 
destination database. The configuration file contains details of the 
JDBC driver class, JDBC database URL, and the username and password 
used to access the database. All of the source database information
is prefixed with the word source, and all of the destination database
information is prefixed with the word destination.

Most of the information can be found by logging into the EPS as an 
administrator and selecting "Database" from the left hand menu. The only
piece of information not displayed is the password, which should be 
obtained from your system administrator.

** Migration **

1) Modify either migrate.bat or migrate.sh (depending on which platform you 
are using) to include the JDBC driver files for both the source and 
destination database. 

Example: If you're migrating from HSQLDB (the database shipped with the 
EPS installer) to Oracle you would need a line similar to the following;

For Unix (migrate.sh) use colons to separate the jar files;
java -cp hsqldb.jar:ojdbc14.jar:epsdb_migrate.jar net.enterprisedatasafe.eps157.DBMigrator configuration.txt

For Windows (migrate.bat) use semi-colons to separate the jar files;
java -cp hsqldb.jar;ojdbc14.jar;epsdb_migrate.jar net.enterprisedatasafe.eps157.DBMigrator configuration.txt

2) Run the migrate batch file or script.

You should now see the schema being verified and then the data copied.