Home Forums SQL Server 2005 Administering upgrade SQL Server 2005 developer ed to standard ed RE: upgrade SQL Server 2005 developer ed to standard ed

  • Hi

    The 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 standard

    http://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 /qb

    The same as you but no addlocal and a few other features in the upgrade list