1. Database Installation

Below are few steps to create both prod and stg databases and how to run the initial load.

  1. Extract the AGR zip folder (named 6.X-rX.zip) and locate it on any drive you choose on the web server. Rename the folder to agr, the path will be referred as …\agr

inst

Note: Check if the zip folder is blocked and unblock it by right-clicking and going into Properties-General and clicking the Unblock button. If no Unblock is visible the zip folder is not blocked.

The db creation scripts are located on following path: …agr\db_scripts

Production database

  1. Modify and execute agr_prod_step_1_create_db.sql
  • Modify the @db_file_path
  • Modify @log_file_path
  1. Execute agr_prod_step_2_full_script_6.X-dbX.sql on the database created in previous step.

Remember to execute on PROD database.

  1. Execute agr_prod_step_3_initial_load.sql

Staging Database

  1. Modify and execute agr_stg_step_1_create_db.sql
    • Modify the @db_file_path
    • Modify @log_file_path
  2. Modify and execute \agr_stg_step_2_agr_stg_nav_6.x-dbx.sql on the database created in previous step.
    • Note: remember to execute on the STG database.
  3. Execute agr_stg_step_3_initial_load.sql