How to upgrade OnGuard version 5.11.105 or older to version 6.3.249 with SQL Server 2008
Procedure Steps
When upgrading an OnGuard system from version 5.11.105 or older to version 6.3.249 with SQL Server 2008, some special steps are needed to make the upgrade complete successfully. When the upgrade occurs, there are two Database Setups that need to run. The first Database Setup (Legacy) will upgrade the database schema to version 5.11.216. Then, the second Database Setup will run and will upgrade the database schema to version 6.3.249.Legacy Database Setup uses ODBC to authenticate and communicate with the database. Legacy Database Setup will only work with the ODBC SQL Server driver.
SQL Server 2008 will not communicate properly with the ODBC SQL Server driver. Instead, SQL Server 2008 must use the ODBC SQL Native Client or SQL Native Client 10.0 driver.
In this scenario, the Legacy Database Setup is never going to be able to establish communication with the database. Legacy Database Setup needs to use the SQL Server driver, but SQL Server 2008 will not work with the SQL Server driver. SQL Server 2008 needs to use the SQL Native Client driver, but Legacy Database Setup does not know how to communicate with the SQL Native Client driver.
You have the following options if you are in this scenario:
1) Use SQL Server 2005. This can be installed instead of SQL Server 2008, or installed on another computer to perform the upgrade. Refer to article 1841, "How to upgrade OnGuard 5.11.105 or older to version 6.3.249 with SQL Server 2005", for more information.
2) Typically there will be a new OnGuard server for this upgrade, since the old server will be fairly old. If this is the case, you can upgrade the old OnGuard server to version 5.11.216, 5.12.012, or 5.12.110, then run Database Setup. To do this, you will need a license file for the specific version that you are upgrading to. Once Database Setup is complete, you can create a backup of your database and restore it to the new server running SQL Server 2008. Then, run Database Setup on the new OnGuard server to upgrade the database schema to version 6.3.249.
Applies To
OnGuard 2009 (6.3.249)SQL Server 2008
