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
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 - ...Email using SQL DBMail
If you are using a full version of SQL Server, then using SQL DBMail is a robust, fast and trouble free mechanism to send emails (this is especially true if the VisitorRego appliance is not connected to the network). The SQL DBMail profile needs to ...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 ...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 ...Set Windows Firewall to allow port 1433 (SQL) connections (inbound and outbound)
Quick and easy video tutorial of how to set Windows Firewall to allow port 1433 (SQL) connections (inbound and outbound). Link: https://www.youtube.com/watch?v=EaoNnZGy1T8