How to Upgrade SQL – Hawk Ridge Systems

Problem

When upgrading Solidworks PDM to a newer version, it is often necessary to upgrade your SQL version if it does not meet the system requirements. PDM Professional will require SQL Standard or SQL Enterprise while PDM Standard will only run on an instance of SQL Express. This article will help you upgrade your SQL.

Solution: Update SQL

Before attempting to Upgrade any PDM Server components, please be sure to create backups of your data.

The first step to updating your SQL is to confirm the compatibility with your Windows Server Operating System.

SQL Server in Windows operating system - SQL Server | Microsoft Learn

If you need to upgrade SQL Standard, the paid for version that is needed for PDM Professional, you will need to get the installation files from the Microsoft Admin Center. Here is the link: Admin Center.

Below are the links for SQL Express for PDM Standard:

SQL 2016 SP3:

KB3177534 - How to obtain the latest service pack for SQL Server 2016 (microsoft.com)

SQL 2019:

Download Microsoft® SQL Server® 2019 Express from Official Microsoft Download Center

SQL 2019 latest cumulative update (you will need to do this after upgrading to SQL 2019):

Download SQL Server® 2019 for Microsoft® Windows Latest Cumulative Update from Official Microsoft Download Center

SQL 2022:

Download Microsoft® SQL Server® 2022 Express from Official Microsoft Download Center

SQL 2025:

Download Microsoft® SQL Server® 2025 Express from Official Microsoft Download Center

After installing the executable, you will want to run it as administrator. Be sure to select Custom.
After selecting custom, you will select install.
Under the Installation section of the SQL Server Installation Center, you need to select Upgrade from a previous version of SQL Server.
You will accept the license agreements and select Next.
You will then select your instance that PDM exists on. Then hit Next.
If you have any features, you will select them in the options prior to this next screen shot. If you do not have have any features, it will automatically send you to the last step. This process can take a fair amount of time depending on the size of your database.
After completion, you will have to restart your server.
If you did not upgrade the SQL Cumulative 2019 update yet, you will receive the following error when trying to upgrade your PDM database.
Please download the latest cumulative update from the Microsoft website. Run the executable and accept the license agreement, then select Next.
Select all PDM existing instances, then hit Next.
Select Next.
Select Update.
You will need to restart your server after the cumulative update.