-
Título
How to upgrade to version 8 creating a new database and converting the old database to an archive database -
Descripción
When upgrading Active Administrator, there is no upgrade path from versions of the product previous to 7.0
In addition, there are upgrade instances where the existing database may not upgrade gracefully or encounters errors during the upgrade
-
Causa
When upgrading from Active Administrator 6.5 or any previous version, the upgrade scripts cannot perform the correct schema change for the 8.0 database.
In some cases, the existing database may suffer from mild corruption or index fragmentation which causes an otherwise valid database to fail the upgrade
-
Resolución
Install Active Administrator 8 as a new instance, not an upgrade.
Manually upgrade the 'old' database to the correct 8.0 schema and connect the database as an 'extra' archive database, or 'Reporting Archive'. (SQL scripts to manually upgrade older versions of the database are available from Quest Technical Support)
CREATE NEW DATABASES FOR ACTIVE ADMINISTRATOR 8:
* Close Active Administrator applications* Open AA Configuration Wizard and run the applicationThe second screen of the wizard offers options to 'use an existing database' or 'createa new database* Select the option to create a new database and step thru the rest of the AA Configuration Wizard
* Once the Wizard finishes successfully, open the Active Administrator Console > Agents
* Remove all existing audit agents and reinstall themLocation of the database is hard coded in each agent.The agents must be re-installed to recognize the new database.
How to convert an existing database into an archive database