If you want to transfer an entire existing EPX repository to another EPX server installation, there are a handful of values in the database that must be changed (unless the destination server name is exactly the same as the current server name).
The following instructions apply to all supported repository types, but do assume that the source and target installations are using the same type of repository.
From the source EPX installation, create a backup of the database.
Stop all EPX services and processes on the target (destination) EPX installation.
Restore the database to the target installation.
On the target EPX installation, browse the <EPX>\bin\esjdbc.properties file and find the value of the server.list property (assuming there is just one value; otherwise, find the one for the repository being replaced).
Use the native or ODBC client tool to connect to the target database and execute the following command, replacing XXX with the value found in step 4:
update s_server set name='XXX', server_uid='XXX'
To clarify, in the repository, there is an EPX metadata table named s_server, and the name and server_uid column values need to match the name as it appears in esjdbc.properties.
Restart the EPX services and processes on the target EPX installation.