Upgrade the Jet Services Database

Requires Administrator Permissions and Knowledge

Overview

When installing the Jet Service Tier for use with Jet Reports, you must select the database that will be used with the Service Tier.

You can specify an entirely new database or select an existing database. If you select an existing database, you have the option of upgrading that database or overwriting it.

Upgrade vs Overwrite

1. Upgrade

   When upgrading an existing Services Database, you will be presented with the option of performing a database backup which will be written to the default SQL Server backup location.

   1. This requires that the user running the installer be a member of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles.
   2. SQL Server must have permissions to write to the default backup location. See the Microsoft documentation for more detailed information on SQL Server backup requirements.

   The database schema will be upgraded to the latest version and your existing data will be preserved.

   If the original database is from a version which supported distribution groups (and distribution groups with active users exist in the database), those users will be converted to regular users and the distribution groups will be removed.

2. Overwrite

   If you choose to overwrite an existing database, all previous data will be deleted

   This option is intended for the following:

   • When you are installing an official release of Jet Reports on a system which a test or beta version was previously installed
   • Other situations when you wish to remove all previous settings and data and start from scratch.

Related Articles

• Installing the Jet Service Tier
• What is the Jet Service Tier?