Moving a Database to Another Location
Under certain circumstances you might wish to move a CentraSite database from an existing CentraSite installation into another CentraSite installation, either on the same machine or on a different machine. Examples of such situations are:
When resources for processing become insufficient.
In a disaster recovery scenario.
As part of a side-by-side product installation, whereby two versions of
CentraSite can exist on the same machine.
Moving a CentraSite database to another machine is not supported in the following scenarios:
if the architectures of the source and the target machine is with different byte orders (big-endian versus little-endian)
if the source machine is a UNIX system and the target machine is a Windows system.
If you are not sure whether moving a database is supported in your environment, contact a technical representative of Software AG.
The CentraSite registry/repository contains environment-dependent data. This data has to be adjusted to the new environment when the data is moved to another machine.
The CentraSite kit contains a command line script that allows you to create a new database from an existing backup and to modify the data to the needs of the new environment. On Windows, the script is MoveCentraSiteRR.cmd, and on UNIX the script is MoveCentraSiteRR.sh.
The steps performed by the script are:
Calculate database space sizes
Delete the existing
CentraSite database
Create a new
CentraSite database
Adjust the environment specific data
Create a new backup containing the modifications
The script is called with 3 parameters as follows:
MoveCentraSiteRR.cmd <BackupFilename><Username><Password>
The parameter <BackupFilename> is the name and path of the existing backup file. The script can only be run using the credentials of the predefined user DefaultUser, so <Username> must be DefaultUser and <Password> must be the password of this user.
The script must be called from the bin\cfg location of the target CentraSite installation.
Important: | The contents of the backup file will overwrite the database of the target CentraSite installation. |
Example:
C:\SoftwareAG\CentraSite\bin\cfg MoveCentraSiteRR.cmd C:\temp\CS820test.2B0 DefaultUser PwdForDefUser