Upgrade MS SQL Server and MS SQL Express

Upgrade MS SQL server to a newer version, or MS SQL Express to MS SQL Server.

Upgrade versions of MS SQL Server

You can upgrade your version of MS SQL server to the more recent version of your preference; for example from 2008 to 2014, or 2012 to 2016, and so on.

  1. From http://www.microsoft.com, download the version of SQL Express you want to upgrade to.
  2. Select Installation and begin the Upgrade from SQL Server 20XX.
  3. Continue through the pre-installation process. Pre-request files and services are updated. Setup Support Rules are processed.
  4. On the Select Instance screen, select the Autodesk Vault instance to upgrade and confirm instance settings. Click Next.
  5. Accept the default features on the Select Features screen by clicking Next.
  6. On the Instance Configuration screen, click Next.
  7. On the Ready to Upgrade screen, click Upgrade. Setup will complete and upgrade the AutodeskVault SQL instance to the version you downloaded.

Upgrade Microsoft SQL Express to Microsoft SQL Standard or Higher

Upgrade a SQL Express installation to a full version of SQL using a media which does not include a service pack, or higher, using one of the following methods.

Note: A server console backup is recommended before performing either of these methods

Method One

  1. Run the full version of SQL setup application.
  2. Select Maintenance > Edition Upgrade.
  3. Select the AutodeskVault instance and start the upgrade.
  4. After the upgrade is complete, apply the latest SQL service pack since this upgrade actually does not have on and it is not transferred from SQL Express.

Method Two

  1. Create a full backup of your vault using the server console. Note: In later steps, you delete all your vault databases. Validate that you can restore this backup on a test server before proceeding. Do not continue if your test restore fails. Correct any problems you have with the backup before continuing these steps.
  2. After the test restore is successful, open the ADMS Console and delete all vaults and libraries listed. Then select Detach Master Vault from the Tools menu.
  3. Make sure that all users are logged out of the vault.
  4. Completely uninstall SQL Express, including the following applications in this order:
    • Microsoft SQL Server 2XXX Note: If you have more than one instance of SQL Express installed, be sure to uninstall only the AutodeskVault instance. DO NOT uninstall any other part of SQL after this step is complete.
    • Microsoft SQL Server 20XX Browser
    • Microsoft SQL Server 20XX Native Client
    • Microsoft SQL Server 20XX Setup Support Files
    • Microsoft SQL Server VSS Writer
  5. Delete the SQL Express folders from Program Files (including data files). If your Vault databases are located on a different drive, be sure to delete the files in this location as well.
  6. Install the full version of SQL with an AUTODESKVAULT instance as in the "Pre-install Microsoft SQL Server" section.
  7. Install the Microsoft SQL release for your Vault product.
    Note: Refer to the chart on this page or see your Vault System Requirements for which SQL release you should install.
  8. Restore the backup that you created in step one using ADMS Console.

Parent topic: Phase 2–Upgrade SQL