Micro Concepts Technical Document
Autodesk Vault:
Upgrading
Microsoft is stopping support for SQL 2005 in 2011. If you have an existing Autodesk Vault installation, you will probably be using SQL 2005 and that will require updating to SQL 2008. Microsoft’s timeline is available on a link from the Micro Concepts Blog here:
http://microconceptstechnical.blogspot.com/2011/01/microsoft-sql-2005-retirement.html There are two main scenarios for the upgrade.
1. Upgr ade from SQL 2005 Express Edition:
If you are using the free version of SQL installed from the Autodesk Vault DVD you can upgrade to the SQL 2008 Express database which can be downloaded from Microsoft. This document details that process.
2. Upgr ade from SQL 2005 Developer, Workgroup, Standard or Enterprise Editions :
The 2008 version of your database will have to be purchased from your Microsoft supplier before upgrading your server. Please contact your IT Department to budget and plan for this upgrade. If you need to check which version of SQL you have installed, the appendix in this document (Page 8) has a solution to query your database to return the version information.
Which SQL should you be using?
SQL Express is the usual version to install when starting to use Vault. The Express database is provided by Microsoft free of charge and is included in the installation of Vault server. The Express database does however have some limitations. The database size is limited to a maximum of 4 or 10GB*, it will only address 1GB RAM and will only use one processor core. Vault installations may require upgrading to a full version of SQL which you will have to purchase. Full SQL removes the limitations of the initial installation and provides support for replicated multi site Vault installations.
Microsoft SQL 2008 Editions Matrix:
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx
*SQL Express 2008 has a 4 GB limit. SQL Express 2008 R2 has a 10GB limit. SQL Express 2008 R2 is supported from Vault 2012.
32 and 64 bit SQL Express
The default Vault server installation will install 32 bit SQL Express on 32 and 64 bit servers even though Vault is supported on both versions of SQL. It is not possible to upgrade a 32 bit SQL installation to 64 bit. If you want to change the version of SQL you should backup the Vault, uninstall the Vault server , uninstall the existing SQL, install the 64 bit SQL creating the AutodeskVault instance, reins tall the Vault server and restore the Vault backup. The benefits of 64 bit computing (increased memory allocation and multiple processor support) are not utilised by SQL Expr ess due the limitations explained above. You may wish to follow this procedure if upgrading to full SQL 64 bit but there is no benefit while using SQL Express.
If you have a 64 bit server but are unsure of the SQL version installed, check th e installation folder. ‘Program Files’ will be used by 64 bit SQL and ‘Program Files (x86)’ will be used by 32 bit SQL.
Downloading the SQL 2008 Express R2 installation
The SQL 2008 Express download can be found by searching for ‘SQL Express 2008 R2 download’ in your Internet browser or following this link. You can install 32 or 64 bit versions depending on your server operating system:
Upgrading SQL Express 2005 to SQL Express 2008 R2
Before upgrading your Vault database you should create a Vault backup. You should stop users accessing the Vault during the upgrade process. Your server may also require a reboot during the upgrade.
Run the SQL 2008 Express R2 download on your Vault Server to start the upgrade process. The SQL 2008 Express R2 installation will undertake many checks. If no issues are found, the dialogues are suppressed. This document does not show any failures during checking.
Agree to the License Agr eement and press Next >.
Select the SQL instance to upgrade by choosing AUTODESKVAULT in the drop down list and then pr ess Next >. If you dont see this screen, you may be installing the wrong version. (64 bit not 32 bit )
Your SQL Expr ess 2008 R2 update is complete. Pr ess Close.
Note that while a new SQL folder (MSSQL10_50.AUTODESKVAULT) has been created, the databases remain in their previous location. The image shows the databases in their default location in the previous MSSQL.1 folder.
There is no configuration required in the Autodesk Data Management Server Console or on the Clients after upgrading the database on the server.
Appendix:
Determining which version of SQL you have installed
If you are unsure which version of SQL you have installed, you can create and run the following files to query the database.
Create a tex t file called ‘Which SQL version.bat’ containing the following line of tex t:
osql -S localhost\autodeskvault -U sa -P AutodeskVault@26200 -n -e -i “sql query.sql” -o "Which SQL version result.txt"
Create a tex t file called ‘sql query.sql’ containing the following two lines of text:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') Go
Double click on the ‘Which SQL version.bat’ file. A ‘Which SQL version result.txt’ file will be created. The content of the txt file will be:
(Many line spaces have been removed below you will need to scroll down to the information) SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
--- ---
10.50.1600.1
RTM
Express Edition with Advanced Services (1 row affected)
Results:
Product version 10.50.x.x = SQL 2008 R2
10.0.x.x = SQL 2008
9.x.x.x = SQL 2005
Product level RTM = no service packs applied, SP1, SP2, SP3
Edition Express Edition Free software downloads to upgrade from 2005
Developer Edition Source a software upgrade from your Microsoft supplier
Workgroup Edition Source a software upgrade from your Microsoft supplier
Standard Edition Source a software upgrade from your Microsoft supplier
