dbTalk Databases Forums  

Upgrade SQL 2000 Standard to Enterprise edition

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Upgrade SQL 2000 Standard to Enterprise edition in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
wayne
 
Posts: n/a

Default Upgrade SQL 2000 Standard to Enterprise edition - 04-23-2007 , 11:14 AM






Is there a white paper for this upgrade or does anyone know the proceedure
and complications that may occur.

Reply With Quote
  #2  
Old   
Andrew J. Kelly
 
Posts: n/a

Default Re: Upgrade SQL 2000 Standard to Enterprise edition - 04-23-2007 , 11:42 AM






I don't know of a white paper but it should be pretty straight forward. You
can either unistall the existing one and install EE or run the set for EE
and it should do an upgrade in place.

--
Andrew J. Kelly SQL MVP

"wayne" <wayne (AT) discussions (DOT) microsoft.com> wrote

Quote:
Is there a white paper for this upgrade or does anyone know the proceedure
and complications that may occur.



Reply With Quote
  #3  
Old   
Hari Prasad
 
Posts: n/a

Default Re: Upgrade SQL 2000 Standard to Enterprise edition - 04-23-2007 , 11:35 PM





You can upgrade it directly from standard to enterprise SQL 2000. But I
recommend you to upgarde it to SQL Server 2005.



Steps to perform Edition Upgrade (From BOL)

To upgrade a SQL Server 2000 installation to a different edition of SQL
Server 2000


1. Insert the Microsoft® SQL Server 2000T compact disc for the edition you
want to install into your CD-ROM drive. If the compact disc does not
autorun, double-click Autorun.exe in the root directory of the compact disc.


2.. Select SQL Server 2000 Components, select Install Database Server, and
then setup prepares the SQL Server Installation Wizard. At the Welcome
screen, click Next.


3.. In Computer Name dialog box, select Local Computer or Remote computer.


4.. In the Installation Selection dialog box, click Upgrade, Remove, or
Add Components to an existing instance of SQL Server, and then click Next.


5.. In the Instance Name dialog box, click Next.


6.. In the Existing Installation dialog box, click Upgrade your existing
installation, and then click Next.

7.. If Setup detects that you are doing an edition upgrade, the Upgrade
dialog box appears. Click Yes, Upgrade my <text specific to the upgrade> to
upgrade the feature set of your current installation, and click Next.


8.. After the upgrade is completed, you are prompted as to whether you
want to install additional components. If you click Yes, the Select
Components dialog box appears. Accept the defaults or select the additional
components you want to install, and then click Next. You can select an
item in the Components list, and then select items from the related
Sub-Components list. Click to select items you want to install; clear the
check box of the items you do not want to install.


9.. When you are finished specifying options, in the Start Copying Files
dialog box, click Next.


10.. In the Setup Complete dialog box, click Yes, I want to restart my
computer now, and then click Finish to complete the edition upgrade.




Thanks
Hari


"wayne" <wayne (AT) discussions (DOT) microsoft.com> wrote

Quote:
Is there a white paper for this upgrade or does anyone know the proceedure
and complications that may occur.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.