FastStats system SQL databases

Note: The Q2 2015 release introduced a Database Update Wizard process for use in systems where both the WebService & FastStats Service configurations are stored in a configuration database (typically named ‘FS_Config’). The following steps assume this is the case.

To update any FastStats System SQL databases:

1. Launch the FastStats Configurator running on the FastStats Server, then click Database Management.

2. Select the Database Update Wizard, then click Start Wizard.

   The Update Database Wizard opens.

3. Click Edit and define a connection string to connect to your Configuration database (usually named ‘FS_Config’).

   

   Note: If you are using a SQL Server Express edition, you probably need “\SQLEXPRESS” on the SQL Server name. The default ‘faststats_service’ account typically used for the FastStats Service and FastStats Web Service is not sufficient for this as the script includes system level changes (e.g. to alter database recovery settings).
   
   

4. Click Browse.

5. Highlight the configuration you wish to update, then click OK.

   This returns you to the Update Database Wizard.

6. Click Next.

7. Select the database(s) to update, then click Next.

   

8. Click Run Scripts.

   Note: Clicking View Notes gives you the ability to copy the script to view its contents. Each Update Database script is then run, with a progress bar showing completion status. A View Log button becomes available for each script as it is run.

9. If errors have occurred, then this is reported in the same column as ‘Complete’ and ‘Running’ in the screenshot below.

   

   Important: Use the Restart button to restart the wizard for each configuration you have defined in your configuration database.

10. Click Finish when you have updated each configuration you have defined in the configuration database.