Upgrade the PI AF SQL Server database
- Last UpdatedOct 10, 2024
- 1 minute read
- PI System
- PI Server 2024 R2
- PI Server
The PI AF SQL Server database must be upgraded by manually executing the SQL scripts on the active node in the SQL Server Cluster. You do not need to run the PI Server install kit on any of the PI AF SQL Server database machines. You can instead download the SQL Scripts from the Customer Portal and manually execute these scripts without running the install kit. This is the least intrusive method of upgrading the PI AF SQL Server database.
Note: To run the necessary scripts from the command line, you must first install the sqlcmd utility, available with SQL Server. For information about sqlcmd, see the Microsoft topic sqlcmd Utility.