Upgrade your existing scheduler database

注意:

ArcGIS Enterprise 10.9.x, part of the ArcGIS 2021 releases, are the last ArcGIS Enterprise releases that support services published from ArcMap. You are encouraged to migrate automated review workflows to ArcGIS Data Reviewer capabilities available in ArcGIS Pro attribute rules.

At ArcGIS Server 10.5 there is an update to the schema of the Scheduler database that stores schedules used by the Data Reviewer ArcMap runtime-based server object extension (SOE). The default SQLite scheduler database will be upgraded as a part of the 10.5 update. For enterprise scheduler databases, you must manually run the migration scripts using the process described here.

注意:

This upgrade process applies to Microsoft SQL Server only.

1. Open Microsoft SQL Server Management Studio.
2. On the Connect to Server dialog box, perform the following steps:
   1. Click the Server type drop-down arrow and choose Database Engine.
   2. Click the Server name drop-down arrow and choose a server that will store the scheduler tables.
   3. Click the Authentication drop-down arrow and choose an authentication type.
3. Click Connect.
4. On the main menu, click the Open File button.
5. Browse to the location of the upgrade_sqlServer file.

   This file is located in <ArcGIS server install folder>\ArcGISDataReviewerServer\Server<version>\sql\upgrade_scripts.

6. Click Open.

   The contents of the file load into the query window.

7. At the top of the file, change [enter_db_name_here] to the name of the database that will store the scheduler tables.
   use [drs_scheduler]

8. Click Execute to run the SQL statements.

   The scheduler tables are updated to match the 10.5 release.