HOW TO

Copy data workspace connection information to a new database with Microsoft SQL Server and ArcGIS Workflow Manager

Last Published: October 7, 2020

Summary

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. 

Procedure

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.
  1. In ArcGIS Desktop, search for the Geoprocessing toolbox.
  2. Expand Workflow Manager Tools > Configuration > Import Job Data.
  3. Specify the parameters as shown below.
    1. For Input JXL/Acknowledgement, use the .jxl file generated from the Export Job Data tool.
    2. Check the Merge option to combine the previous database contents with contents of the input configuration file. Optionally, specify Input Database Path (.jtc) and Repository Name.
    3. Click OK.

Copy the Workflow Manager schema table into a new database

  1. In Microsoft SQL Server Management Studio, use the following code to copy the Workflow Manager schema table JTX_DATABASES to the new database to bring in the data workspace connection information.
INSERT INTO [<new database name>].[dbo].[JTX_DATABASES]
SELECT *
FROM [<old database name>].[dbo].[JTX_DATABASES]
  1. In ArcGIS Workspace Manager Administrator, right-click the new database, and click Refresh. The .jtx databases are now listed under Data Workspaces.

Article ID: 000022045

Software:
  • ArcMap 10 7
  • ArcMap 10 8

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options