How to upgrade the database schema for all my GFI Archiver databases?


The GFI Archiver Bulk Schema Upgrader tool can be used to quickly upgrade the database schema for a number of GFI Archiver databases to the latest schema with one click of a button.

To upgrade or verify the schema for a number of GFI Archiver databases, perform the following:

  1. Open the GFI Archiver Bulk Schema Upgrader found at: ..\GFI\Archiver\BulkSchemaUpgrader
  2. Select which databases you wish to upgrade by selecting the checkbox next to the appropriate databases
  3. Click on the Upgrade button to upgrade and verify the database schemas
  4. You will be prompted to enter the credentials which are to be used for the schema upgrade. The credentials supplied need to be for the user assigned the dbo role for the GFI Archiver database. We strongly suggest using the 'sa' credentials for this process. If the 'sa' credentials are not available, the credentials supplied need to be for the user assigned the db_owner role on the GFI Archiver database

You can create a user with the db_owner role by performing the following:

  1. Open the Microsoft SQL Server Management Studio
  2. Expand Databases > GFI Archiver database > Security > Users
  3. Right Click on Users and select New User
  4. Enter a new User name and enter the same user name as login name
  5. Select the db_owner as default schema
  6. Under Schemas owned by this user select all GFI Archiver databases and db_owner under Database role Memberships and click OK
  7. Enter these credentials in the GFI Archiver Bulk Schema Upgrader

You can confirm the user with the dbo role by performing the following:

  1. Open the Microsoft SQL Server Management Studio
  2. Expand Databases > GFI Archiver database > Security > Users
  3. Right Click on dbo and select Properties
  4. Use the same Login name displayed under the dbo properties
  5. Enter these credentials in the GFI Archiver Bulk Schema Upgrader

Notes:

  • The GFI Archiver Bulk Schema Upgrader is launched automatically as soon as the GFI Archiver installation is complete
  • GFI Archiver does not store the credentials supplied in the Bulk Schema Upgrader for security purposes