Performing a database upgrade
In order to upgrade the vRanger database, perform the steps described below.
Prerequisites
•
Upgrading the database (32-bit SQL Server)
To upgrade an older 32bit version of SQL Server to a newer 32bit SQL server
2 Run the program and the SQL Server Installation Center wizard is displayed.
3 In the left navigation area, click Installation and then click Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012.
4 On the License Terms page, review the license agreement and, if you agree, select I accept the license terms, then click Next.
5 In the Global Rules window, the setup procedure will automatically advance to the Product Updates window if there are no rule errors.
6 The Microsoft Update page will appear next if the Microsoft Update check box in Control Panel>All Control Panel Items>Windows Update>Change settings is not checked. Putting a check in the Microsoft Update page will change the computer settings to include the latest updates when you scan for Windows Update.
7 On the Product Updates page, click Next to include the latest SQL Server updates. The Install Setup Files page is displayed, where the setup files are copied and then the installation automatically starts.
8 On the Install Setup Files page, Setup provides the progress of downloading, extracting, and installing the Setup files. If an update for SQL Server Setup is found, and is specified to be included, that update will also be installed.
9 In the Upgrade Rules window, the setup procedure will automatically advance to the Select instance window if there are no rule errors.
10 On the Select Instance page, specify the instance of SQL Server to upgrade.
11 On the Select Features page, the features to upgrade will be preselected. A description for each component group appears in the right pane after you select the feature name.
12 On the Instance Configuration page, specify the Instance ID for the instance of SQL Server.
▪ Instance ID - By default, the instance name is used as the Instance ID. This is used to identify installation directories and registry keys for your instance of SQL Server. This is the case for default instances and named instances. For a default instance, the instance name and instance ID would be MSSQLSERVER. To use a non-default instance ID, provide a value for the Instance ID textbox.
▪ Installed instances - The grid will show instances of SQL Server that are on the computer where Setup is running. If a default instance is already installed on the computer, you must install a named instance of SQL Server.
13 On the Server Configuration - Service Accounts page, the default service accounts are displayed for SQL Server services. The actual services that are configured on this page depend on the features that you are upgrading.When you are finished specifying login information for SQL Server services, click Next.
14 On the Full-Text Search Upgrade Options page, specify the upgrade options for the databases being upgraded.The Feature Rules window will automatically advance if all rules pass.
15 The Ready to Upgrade page displays a tree view of installation options that were specified during Setup. To continue, click Install. SQL Server Setup will first install the required prerequisites for the selected features followed by the feature installation.
17 After installation, the Complete page provides a link to the summary log file for the installation and other important notes. To complete the SQL Server installation process, click Close.
18 Open SQL Server Management and set the compatibility level for the selected database.
Upgrading the database (64-bit SQL Server)
To upgrade an older 32-bit version of SQL Server to a newer 64-bit SQL server
1
4
5 Open SQL Server Management and set the compatibility level for the selected database.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center