When upgrading SOLIDWORKS PDM to 2022 or later, it is often necessary to upgrade SQL itself. 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.
Before attempting to Upgrade any PDM Server components, please be sure to create backups of your data.
After upgrading PDM Server to 2022 or greater from an earlier version, you will need to upgrade your SQL version if it is not 2016 or higher.
If you have not updated your SQL, you will run into the error “SOLIDWORKS PDM Support SQL 2016 and above” during the Database Upgrade step.
You may also see the following error when attempting to log into the vault.
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
After verifying compatibility, use Microsoft’s website to obtain the installation files. Choose the version that your server is compatible with. (2016 or 2019)
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 Volume License Service Center. Here is the link: Volume Licensing Service Center (microsoft.com)
Below are the links for SQL express:
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):
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 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 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.
After you restart your server, the SQL upgrade is complete.
To finish the database upgrade, navigate to your SolidWorks installation media and run the Upgrade.exe
\SOLIDWORKS 202# SP0#\SOLIDWORKS 202# SP0#\SWPDMServer\Upgrade
Open the upgrade tool and run it. Select your vault and click next.
Select next.
Select Finish.
After this, you should now have a working PDM client and server with all compatible components.
Contact Us
For further technical support please contact Hawk Ridge Systems at 877.266.4469 for the U.S. or 866.587.6803 for Canada.
Comments
Please sign in to leave a comment.