Step 2 - SQL Update
Some upgrades may require changes to the database. If you are using a Microsoft Access database... Sit back! Relax! Your database will automatically update when you install with the new version.
If your database is being held on an SQL server, then you will need to run a script against the VisitorRego.NET database.
Note: To do this, you will need access to, and the relevant permissions for your SQL Server Management Studio. If you do not have these, contact your IT department for help with this.
The VisitorRego support team will have emailed you a link to download an SQL update script. Save this file, usually called VisitorRego_Update.sql, into your VisitorRego.NET root directory or onto a USB key if your server access is not on the VisitorRego PC.
It is always advisable to back-up before you make any changes to the database.
Once at the PC with SQL access, double click the update file to open with SQL server management studio (or Right-click to'Open with'). SQL studio will ask for a password to log you on. Enter these details in the required fields.
Once in your SQL server, make sure the name of the database the script is to run against matches the name of your VisitorRego database (it should default to VisitorRego) and then click ‘Execute’.
The SQL management server will advise you if this was successful.
Now you are ready to move on to Step Three, Uninstall and Reinstall.
If your database is being held on an SQL server, then you will need to run a script against the VisitorRego.NET database.
Note: To do this, you will need access to, and the relevant permissions for your SQL Server Management Studio. If you do not have these, contact your IT department for help with this.
The VisitorRego support team will have emailed you a link to download an SQL update script. Save this file, usually called VisitorRego_Update.sql, into your VisitorRego.NET root directory or onto a USB key if your server access is not on the VisitorRego PC.
It is always advisable to back-up before you make any changes to the database.
Once at the PC with SQL access, double click the update file to open with SQL server management studio (or Right-click to'Open with'). SQL studio will ask for a password to log you on. Enter these details in the required fields.
Once in your SQL server, make sure the name of the database the script is to run against matches the name of your VisitorRego database (it should default to VisitorRego) and then click ‘Execute’.
The SQL management server will advise you if this was successful.
Now you are ready to move on to Step Three, Uninstall and Reinstall.
Related Articles
Loading Staff from Active Directory – AD Update Utility
Active Directory and LDAP can be leveraged to enable automated importation of a staff list into VisitorRego. Active Directory integration is intended for a system administrator or IT specialist to set up. Knowledge of how your Active Directory is ...Step 1 - Backup
The first thing to do when upgrading is to backup your current files. Remember, you can never have too many backups! This means if you get stuck you can always revert back to the previous version without losing any functionality. Create a folder ...Add and Maintain SQL
To add a new custom report you need to tell VisitorRego how to retrieve the data from the database and how to format this data in a report. Open the Custom Reports screen. Note: Before you edit the SQL you need to know the database engine used - ...Step 3 - Uninstall/Re-install
Uninstall The next step is to uninstall the old version of VisitorRego from your computer. To do this, go into your windows Control Panel and select 'Uninstall a Program' from the 'Programs and Features'section. Select VisitorRego.NET and click ...Upgrading - An Overview
Upgrading your VisitorRego System - An Overview VisitorRego software is constantly evolving. It is our aim to take on board customer feedback and use this information to make VisitorRego both as user-friendly and functional as possible. The software ...