Solved: Another SQL Server Upgrade Question

BrianToussaint · ‎Jun 15, 2017

Has anyone done an upgrade from SQL Server 2008 to SQL Server 2012 for Windchill? I know that when I'm done, I'll have to run the collation conversion but my question is do you have to install 2012 separately and import the database or can you run the "SQL Upgrade" to upgrade the database instead? The book is saying the first, but I'm wondering if the second works.

TomU · ‎Jun 15, 2017

Fundamentally you need to have your database loaded into SQL 2012 before you can run the conversion utility. You probably can't simply upgrade the existing SQL install because I don't think it will give you the option to change the collation of the instance itself (including tempdb). There's certainly nothing stopping you from detaching the database, uninstalling 2008, reinstalling 2012, and then reattaching the database again.

View solution in original post

TomU · ‎Jun 15, 2017

Fundamentally you need to have your database loaded into SQL 2012 before you can run the conversion utility. You probably can't simply upgrade the existing SQL install because I don't think it will give you the option to change the collation of the instance itself (including tempdb). There's certainly nothing stopping you from detaching the database, uninstalling 2008, reinstalling 2012, and then reattaching the database again.

BrianToussaint · ‎Jun 15, 2017

Thanks Tom. I was just trying to see if there was an easy way out. I've got instructions for installing two different versions on the same server. Just trying to make up for time lost due to server issues.