Replace SQl 2005 Ent edition with 2005 Standard edition

Last Post 12 Aug 2009 05:31 AM by timcronin. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
timcronin
New Member
New Member

--
11 Aug 2009 11:57 AM
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
timcronin
New Member
New Member

--
12 Aug 2009 05:31 AM
I am guessing I should attach the db's and then add the logins?


Acceptable Use Policy
---