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.
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.
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
