Reputation: 1576
Upgrading from SQL Server 2008 Express to 2008 Developer
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.
- Do I have to make backups of all the data and uninstall express - install developer?
- Is there a quicker way?
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.
Upvotes: 13
Views: 4459
Answers (1)
Reputation: 48432
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.
Upvotes: 2
Related Questions
- How to upgrade SQL Server 2014 Express edition to developer edition
- Problems upgrading to SQL Server Express 2008 SP2
- Migration from SQL Server 2008 R2 Express to SQL Server 2008 R2 Developers Edition
- Moving from SQL Server 2008 Express to SQL Server 2012
- Can i Upgrade SQL server 2008r2 express to sql server 2014 Developer edition
- Upgrading from SQL Server 2008 R2 Express to SQL Server 2008 R2 Enterprise
- Upgrade from SQL Server 2008 Standard to Developer?
- How do I upgrade from SQL Server 2008 R2 Express to 2008 R2 Developer
- Downgrading SQL Server Express 2008 to SQL Server Express 2005?
- SQL Server 2008, developer edition