April 7, 2012 at 12:19 pm
We're building out a new clustered development and clustered production SQL environment and I've made a bonehead move on my development environment.
Instead of installing delevoper edition, I've installed enterprise edition. This is a two node clustered 64 bit instance. I need to "revert" my instance to developer edition.
I know one option is to uninstall and then re-install the correct edition but I was hoping that there is a simpler way. I've done some setup that I would prefer not to redo, although I certainly deserve to have to do so.
Has anyone besides me done this? If so what did you do?
April 7, 2012 at 6:25 pm
Here is what I would do, check with Microsoft. If you have purchased the appropriate licenses for the Developer Edition for your development and testing environment and the proper licenses for the Enterprise Edition for your production environment, I don't think they would make you uninstall the EE from your development/test environment. BUT, they are the ones to tell you that, not us. All information provided here is simply my opinion and has not legal standing.
April 8, 2012 at 3:24 am
I've never tried it but I'm pretty sure you won't be able to use the upgrade wizard. The 2 are essentially the same eition with different licensing constraints. Having said that, why not just put the cd into the passive node and run the upgrade see what happens. If it completes you just need to fail over the instance to complete the action.
Other than that Lynn's suggestion sounds reasonable.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 8, 2012 at 6:13 am
From everything I've read, you'll have to do an uninstall and a reinstall with the different edition.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 9, 2012 at 9:10 am
This exact question came up on these forums a while back. You may be able to wiggle out of doing a full uninstall/reinstall, however do not take licensing advice from a Forum posting. The only way to know if you're covered to leave the Enterprise Edition cluster in place in development is to check with Microsoft.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 9, 2012 at 10:50 am
I can tell you from experience that it is not a valid upgrade path to go from EE to dev. In fact, I just ran into the issue on Friday.
Jared
CE - Microsoft
April 27, 2012 at 2:03 pm
I ended up just uninstalling and re-installing. It was not as big of a deal as I imagined it would be.
Thanks for the advice. I appreciate it!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply