December 15, 2008 at 3:58 pm
what is the cleanest way to downgrade from sql 2005 Enterprise edition to standard edition and from sql 2005 standard edition to developer edition?
December 15, 2008 at 4:06 pm
install a new instance and migrate the objects then remove the old instance afterwards
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2008 at 4:23 pm
You should know that SQL Server 2005 Enterprise Edition and SQL Server 2005 Developer Edition are equivalent, just different licensing (Developer Edition can't be used in a production environment).
December 15, 2008 at 4:37 pm
Actually i want to perform an inplace downgrade. Is it possible to downgrade it without doing uninstall and then re-install it?
December 15, 2008 at 5:05 pm
Saurabh Vegda (12/15/2008)
Actually i want to perform an inplace downgrade. Is it possible to downgrade it without doing uninstall and then re-install it?
No. There is no version downgrade procedure.
1- Take a full backup of all user databases.
2- Script all user databases
3- Script all logins
4- Script all jobs, etc.
5- Uninstall EE
6- Install SE
7- Create all user databases
8- Restore user databases
9- Create all logins
10 - Create all jobs, etc.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply