August 11, 2009 at 1:55 pm
I have a sql 2005 Enterprise Edition which has to be converted to Standard edition on a production boc. I was looking for the best approach.
1st Idea- Script out all logins and SQl Server Jobs
De-attach all db's
Uninstall sql 2005 ent edition
Install SQL 2005 std edition
Attach all db's
Script in logins and jobs
2nd idea Script out all logins and SQl Server Jobs
De-attach all db's
Uninstall sql 2005 ent edition
Install SQL 2005 std edition
Restore master and msdb (if possible)
There is one SSIS package/job which runs on this server.
Any pro's/cons with these ideas?
Thanks
August 11, 2009 at 2:52 pm
-or- go to a sql 2005 standard (make sure it is the same version / sp) and export the registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\checksum
(if your instance isn't MSSQL.1 change it to the right instance)
on your enterprise server: export the same key and store it as a backup.
Then import the value from the std version onto the ent version and restart your instance and it will be standard.
*Obligitory warning - this is undocumented and might stop working at some point, ensure you test this in a non-prod version first*
Ed
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply