InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 22:36:25 GMT20http://www.sqlservercentral.com/Forums/Topic1412532-1292-1.aspx[quote][b]davery 28734 (1/28/2013)[/b][hr]I have a windows 2003 server running sql 2005 with a developer license installed. It's now in production. I have purchased the production license, but my dba is telling me SQL 2005 must be reinstalled for it to be legal. Is there a way to just change the license?[/quote]You can absolutely upgrade a SQL Server 2005 Developer Edition install to any of these without re-rinstalling everything:SQL Server 2005 Enterprise EditionSQL Server 2005 Standard EditionSQL Server 2005 Workgroup EditionIn the installer there is a separate option to upgrade the Edition of an existing instance.[u][url=http://msdn.microsoft.com/en-us/library/ms143393(v=sql.90).aspx]Version and Edition Upgrades (SQL Server 2005)[/url][/u]Now, if you want to upgrade your 2005 Developer instance to 2008 or 2012 then you have to do 2 upgrades, one to 2008 or 2012 Developer Edition and then another to get to 2008 or 2012 Standard or Enterprise Edition respectively.Tue, 29 Jan 2013 06:48:54 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1412532-1292-1.aspxlooks like he's correct to me;according to this page,neither standard nor enterprise will upgrade/replace an existing developer instance:take a look here:[b][url]http://msdn.microsoft.com/en-us/library/ms143393.aspx[/url][/b]so to get everything correct, you need to do a whole DR/ new server kind of thing;script out all the logins, certificates, linked servers , jobs, database mail,etcbackup the database, uninstall/reinstall and then run the scripts to get your logins and settings backMon, 28 Jan 2013 10:51:53 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1412532-1292-1.aspxI have a windows 2003 server running sql 2005 with a developer license installed. It's now in production. I have purchased the production license, but my dba is telling me SQL 2005 must be reinstalled for it to be legal. Is there a way to just change the license?Mon, 28 Jan 2013 10:11:32 GMTdavery 28734