[dba-SQLServer] Installing SQL Server 2000 over XP Developer

Bruce,

Detach the databases and move them to a different directory.
Uninstall the developer version.
Install the full version.
Move the databases to where you want them to be.
Re-attach them.

Just to get it straight, there is not an XP Developer version of SQL Server. 
There are SQL 2000 and 2005 Developer versions which have all the features of
the enterprise version except for the number of users.

Robert L. Stewart
The Dyson Group International
Software for the Non-profit Enterprise
Expanding your Sphere of Knowledge


Quoting dba-sqlserver-request at databaseadvisors.com:

> Date: Wed, 28 Jun 2006 12:38:04 -0400
> From: Bruce Horn <bhorn at pivot-mds.com>
> Subject: [dba-SQLServer] Installing SQL Server 2000 over XP Developer
> 	version
> To: dba-sqlserver at databaseadvisors.com
> Message-ID: <7.0.1.0.0.20060628123756.02074798 at pivot-mds.com>
> Content-Type: text/plain; charset="us-ascii"; format=flowed
>
> Hello List -
>
> Can a fully-licensed SQL Server 2000 be installed over an XP
> Developer version without impacting existing databases?
> We have two databases in the XP Developer version of SQL Server 2000
> and we are going to upgrade to a full license version on the same box
> (Windows Server 2003).
>
> Any information greatly appreciated.
>
> Regards,
> - Bruce