Transferring the Repository Database Between Servers - EnterWorks_Process_Exchange_(EPX) - 10.5

EnterWorks EPX Administration

Product type
Software
Portfolio
Verify
Product family
EnterWorks
Product
Precisely EnterWorks > EnterWorks Process Exchange (EPX)
Version
10.5
Language
English
Product name
Precisely EnterWorks
Title
EnterWorks EPX Administration
Topic type
Administration
Configuration
First publish date
2007
ft:lastEdition
2023-07-28
ft:lastPublication
2023-09-20T03:37:01.911821

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.

  1. From the source EPX installation, create a backup of the database.

  2. Stop all EPX services and processes on the target (destination) EPX installation.

  3. Restore the database to the target installation.

  4. 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).

  5. 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.

  1. Restart the EPX services and processes on the target EPX installation.