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.