HOW TO
The ArcGIS Workflow Manager repository is stored in a .jxl file. The .jxl file contains all the repository information and job information. When importing a .jxl file to a new database, the Data Workspaces folder is not updated accordingly. This is expected behaviour, as the data workspace connection information is not included in the .jxl file due to security reasons.
ArcGIS Workflow Manager standardizes, coordinates, and streamlines the management of data in databases. This article provides instructions to copy data workspace connection information directly from one database to another using ArcGIS Workflow Manager Administrator and Microsoft SQL Server Management Studio.
Note: It is assumed that the geodatabase is administered on geodatabase servers. For more information refer to ArcMap: Set up a database server.
In ArcGIS Desktop, use the Import Job Data tool to import a .jxl file to a new Workflow Manager repository
Note: The Import Job Data tool is available with a Workflow Manager license.
Copy the Workflow Manager schema table into a new database
INSERT INTO [<new database name>].[dbo].[JTX_DATABASES] SELECT * FROM [<old database name>].[dbo].[JTX_DATABASES]
Get help from ArcGIS experts
Download the Esri Support App