Follow

Enterprise Database Upgrade Utility

Mike Frey

Enterprise Database Upgrade Utility

TITLE:

Enterprise Database Upgrade Utility

DATE:

1/10/2014

SUBJECT:

How to run the Enterprise Database Update utility

ABSTRACT:

Comprehensive guide for running the Enterprise Database Upgrade utility.

 

This guide is written for Enterprise 2014.  

This is not a troubleshooting guide.  If you have any technical issues with SolidWorks, please contact Hawk Ridge Systems technical support.

This document is only to be distributed and used by Hawk Ridge Systems customers.  Any other use is prohibited.

 

Before Upgrade

Hawk Ridge Systems highly recommends taking a moment before upgrading your database to check that you are ready:

  1. Backup all databases before performing the upgrade. 
  2. The upgrade should only be run after the Enterprise server components have been upgraded. 
  3. Make sure you have the current SQL System Administrator (SA) password. 
  4. The database upgrade tool can be run from any client system that is on the same version as the server components. 
  5. Make sure that no users are working in the vault.

Upgrade

  1. Insert the Solidworks Enterprise PDM DVD or launch the installation from a network drive.
  2. On the Enterprise PDM installation screen, select How to upgrade from a previous Solidworks Enterprise PDM version.
  3. After step 4 of the upgrade procedure, click Upgrade Database to launch the upgrade wizard.
    • **Note: You can also manually launch the upgrade wizard from the Upgrade folder in the install CD by running Upgrade.exe
  4. Click Yes on the message box warning that upgrade wizard should only be run by an administrator.
  5. Review and confirm you have performed all the prerequisites, then click Next.
  6. Select the SQL server from the drop down list (if it is not listed you can manually type it in) and click Next.
  7. Enter a user name and password for a user with sysadmin permissions on the SQL server and click Log In.
  8. Put a check mark next to the file vault databases that need to be upgraded and click Next.
  9. Click Next again to start the upgrade.
  10. Once the upgrade is finished, review the log to confirm each database was successfully upgraded.  Click Finish.
  11. After the upgrade, reboot the Microsoft SQL Server.  If you do not, you may experience performance drops until you reboot.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments