Re: How to convert the SQL Developer Edition to SQL Standard Edition?

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 09:01:40 -0500

The developer edition does not have any restrictions like that as far as I
know. It is essentially the same as the Enterprise Edition. It sounds like
you have MSDE or the DeskTop Edition installed. To upgrade to Std Edition
you can not avoid rerunning setup for SQL Server to get to Std edition. The
process is not bad though and this should guide you through it:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q325023

 But the I would ensure you have good backups of all your user and system
db's before attempting anything. These may help:

http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server 

-- 
Andrew J. Kelly  SQL MVP
"Kam" <Kam@discussions.microsoft.com> wrote in message 
news:9EA92B28-59BB-4B68-8502-F80288B8F143@microsoft.com...
>I am reaching the db limit in Developer Edition 2000.
> So I would like to convert it to SQL Standard Edition 2000 with no change 
> of
> my existing setting. I don't want to re-install and I want to keep the 
> server
> name, DTS, Analysis services, and mulitple instant of SQL server.
>
> Is there any way to overcome the DB limit in Developer Edition 2000 or
> change it to Standard Edition without uninstall the Developer edition, 
> then
> install the standard edition?

Relevant Pages

  • Re: Upgrading Eavluation Edition
    ... You haven't explained exactly what you wanted to do with SQL Server ... Standard Edition on XP. ... I don't understand the comment about Developer Edition. ... install program failed since SQL Server 2000 Standard doesn't support Windows ...
    (microsoft.public.sqlserver.setup)
  • Re: access as frontend to backend sql 2000
    ... ADE is an "add on" to Access. ... an "imitation" of the entire deployment you plan, ... SQL Server Express may be just the thing for you. ... SQL Server Developer Edition includess development tools, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Is SQL server not installed with VS2005
    ... "The developer edition of SQL Server" does not refer to a particular ... Copyright 1988-2003 Microsoft Corporation Personal Edition on Windows ... You *can* install MSDE 2000 or SQL Server 2005 Express. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: What clients to use with Developer version?
    ... I think maybe you misunderstood what they were suggesting. ... programmable GUI interface. ... off the developer edition of SQL Server is licensed as a development tool ...
    (microsoft.public.sqlserver.clients)
  • Re: What clients to use with Developer version?
    ... expressed that MS Access was not intended to be used with either MSDE, ... nor SQL server 2000 - a statement which contradicted in many Microsoft ... >off the developer edition of SQL Server is licensed as a development tool ... >> and our customer users, since we will not be supporting the ...
    (microsoft.public.sqlserver.clients)
Loading