I'm going to upgrade SQL Server 2005 developer ed to standard ed. Not changing version, just edition. My plan is to detach the databases, uninstall developer ed, install standard ed and attach the databases. My question is about the jobs and user logins. Should I also detach/attach the system databases master and msdb to preserve the jobs and logins?Or should I script them out and run scripts after the standard ed is installed?Is there an easier way to accomplish this upgrade?Thanks very much for any ideas and help.

HiThe problem you have here is that Developer is a higher version than Standard so you can't upgrade that way.You would need to uninstall standard then install Developer.Backup and reinstall databases - or detach and reattach them.For and sys jobs etc you have the easiest method would be to script them out then reapply them.

I am not sure of the best way to copy logins and user permissions though.

I beg your Pardon you can upgrade from Developer to standardhttp://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx

I upgraded standard to dev with this:start /wait d:\setup.exe instancename=MSSQLSERVER upgrade=SQL_Engine,SQL_Data_Files,SQL_Tools90,SQL_Replication skuupgrade=1 /qbThe same as you but no addlocal and a few other features in the upgrade list

I did end up uninstalling developer ed and installing standard. It worked just fine. I ran out of time to keep trying the upgrade method. I will try it again if I ever have the need to do this again. Thanks for all the help.