How to reinstall the AVReporter database?

Discussion in 'Installation' started by Nagy Ottó, Jan 30, 2015.

  1. Nagy Ottó

    Nagy Ottó Administrator Staff Member

    1st step: Delete the previous database version in the SQL Management Studio
    Connect to the SQL server and select the AVRDATA database. Push the delete button or right click on the database name and click on the Delete menu item in the popup menu.
    Important: Check the "Close existing connections"

    upload_2015-1-30_9-30-42.png

    ...and click on the OK button.

    The result is:

    upload_2015-1-30_9-36-29.png

    2nd step: Install the new AVRDATA database
    Start the AVReporter installer and click on the '+' sign in the "SQL Server 2012 Express + database" button.

    - The easy way is that you uncheck the "Intall SQL Server 2012 Express" menu item and click on the "SQL Server 2012 Express + database" button. The database will be intalled into the KONSYS instance.

    upload_2015-1-30_9-55-21.png

    - Custom install: Click on the "Get install files" when the Advanced settings appeared.
    upload_2015-1-30_10-0-54.png

    upload_2015-1-30_9-58-38.png

    Execute the AVRDATA.sql (with local timestamp indexes) or the AVRDATA_UTC (with utc timestamp indexes) in the SQL Management Studio after you connect to the target SQL server.

    The result is:

    upload_2015-1-30_10-9-13.png
    kresekjoy likes this.

Share This Page