It's upgrade time again!
Currently we are running EPDM 2010 SP3 on SQL 2005. We would like to upgrade to EPDM 2011 SP1 and SQL 2008 soon. Any opinions on the best order to do this?
Its recommended, but not required.
I just noticed the SQL upgrade from 2005-2008. I'd consider doing that first. All files must be Saved and Checked In and all Users logged off until the entire upgrade is complete.
You'll find the upgrade instructions in the attached Installation Guide ,review them closely prior to starting.
Thanks for the info, I saw some very good instructions on how to upgrade both EPDM and SQL, but was wondering if there was a prefered order. My boss thinks we should upgrade to SQL 2008 first and then if all goes well upgrade in a few weeks to EPDM 2011 SP1. I've got SolidWorks, Inventor, and AutoCAD 2011 users that would rather have the EPDM upgrade first. I was hoping for a compelling reason to choose one over the other. The EPDM upgrades are usually a breeze not sure about a SQL upgrade. Have you upgraded anyone from SQL 2005 to 2008?
Here is a clip from this site;
Insert the SQL Server installation media, and from the root folder, double-click Setup.exe. To install from a network share, move to the root folder on the share, and then double-click Setup.exe. If the Microsoft SQL Server 2008 R2 Setup dialog box appears, click OK to install the prerequisites, then click Cancel to exit SQL Server 2008 R2 installation.
If the .NET Framework 3.5 SP1 installation dialog box appears, select the check box to accept the .NET Framework 3.5 SP1 License Agreement. Click Next. To exit the SQL Server 2008 R2 installation, click Cancel. When installation of .NET Framework 3.5 SP1 is complete, click Finish.
Windows Installer 4.5 is also required, and may be installed by the Installation Wizard. If you are prompted to restart your computer, restart, and then run SQL Server 2008 R2 Setup.exe again.
When prerequisites are installed, the Installation Wizard starts the SQL Server Installation Center. To upgrade an existing instance of SQL Server, click Upgrade from SQL Server 2000, SQL Server 2005, or SQL Server 2008.
Here's the link:http://technet.microsoft.com/en-us/library/ms144267.aspx
You'll have the upgrade option on the installation wizard.
I would upgrade SQL first --in the off chance that something may happen bad during the EPDM update, SQL 2008's rollback capabilities may be slightly better than SQL 2005's.
Overall I wouldn't spend more time thinking about it.
The SQL upgrade is cake...though it takes a while. (I think it took almost 30 minutes for me.)
I would recommend upgrading SQL first, just as you suggest. That way you know the DB environment is running as it should. Enterprise 2010 will work with SQL 2008. The actual upgrade is really simple, just run the 2008 installer and follow the instructions.
But make sure you back up your databases beforehand - once they are in SQL 2008 format they cannot be restored in SQL 2005
Tor Iveroth, SolidWorks tech support
Thanks all for the input, unfortunately I posed the question a little late. I went with what I was good at and upgraded to EPDM 2011. It went well for the most part, a few clients had dll error messages when first logging into the file vault, errors went away after a second reboot.
We will do the SQL upgrade in a couple weeks. It does not appear to be overly complicated.
Devon mentioned having all documents checked in and all users logged out. I knew this was highly recommended for the Enterprise upgrade but is it also necessary for the the SQL upgrade?
After running the SQL 2008 R2 upgrade on my test server it appears SQL 2005 still exist. Don't upgrades usually remove the old version? Is it ok to uninstall SQL 2005?
Retrieving data ...