Menu
What is the best (or THE) way to change my SQL Express 2008 (with advance...) installation to a 2008 Developer edition?
I need to keep the databases, along with the logins and so on.
I need to upgrade because, I Want to use all the features in TFS 2010.
SOLVED:
In the SQL Server Installation Center, there a Edition Upgrade options found under Maintenance. The only thing is that you have to choose processor type as x86 (as Express is only x86) in the options in the Installation Center. Now my SQL Server is developer.
731
SQL Server Developer is an ideal choice for people who build and test applications. Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications.
You can upgrade a Microsoft SQL Server Express instance using the SQL Server Express installation wizard. The version of SQL Server Express that is delivered with ArcGIS has changed with some releases.
Microsoft SQL Server Developer Edition is now free - Microsoft SQL Server Blog.
We had to do the same thing at one time. I think we simply backed up our database(s) and the master and msdb databases as a precaution, to restore if we had to, which I don't think we did.
83
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
