Skip To Content

Upgrade your existing scheduler database

At ArcGIS Server 10.5 there is an update to the schema of the Scheduler database which stores schedules used by ArcGIS Data Reviewer Server. 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.

Note:

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.