Re: Upgrading MSDE 2000 to SQL 2000 Standered

Hi,


Incase if you are not able to go based on my previous post then

What you could do is:-

1. Install SQL Server 2000 Standard and SP4
2. Backup / detach the databases from MSDE
3. Restore / Attach the databases into SQL Server 2000 standard

Thanks
Hari
SQL Server MVP


"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message
news:%23SC2ErZ1GHA.772@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

We could do this by simply running the SQL Server standard edtion setup
program. Just do a test in your test environemnt.

steps:-

How to perform an edition upgrade within SQL Server 2000 (Setup)
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
SQL Server MVP
"vinu thomas" <vinuthomas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BDA0D1B3-EE30-4474-85D7-63E0E3C5AA01@xxxxxxxxxxxxxxxx
Hi,

is it possible to upgrade MSDE 2000 to SQL 2000 Standered. If so what is
the
simplest and easist way

Thanks
b




.

Relevant Pages

  • Re: MSSQL on XP-Pro
    ... do have backups of the data files and the solomon pgm files on another ... Isn't there a free SQL Server, something open source, that I think I saw ... There are two ways to upgrade. ... upgrade when you run the 7.0 install. ...
    (microsoft.public.sqlserver.setup)
  • Re: tools not installed but setup thinks they are
    ... Reason: Your upgrade is blocked. ... Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books ... and selected "install to local hard drive" for everything, ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Problems and Reporting Services
    ... As I go through the install of R2, I try to upgrade the SQL 2000 ... Reason: Your upgrade is blocked. ... Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books ... information about edition upgrades, see the Version and Edition Upgrades ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL 2000 Standard to Enterprise
    ... Steps to perform Edition Upgrade ... To upgrade a SQL Server 2000 installation to a different edition of SQL ... you want to install into your CD-ROM drive. ... and then click Finish to complete the edition upgrade. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 wont upgrade using R2 discs
    ... Are you sure the default instance you are trying to install isn't MSDE? ... Microsoft SQL Server 2005 Tools ... But I assume I need to upgrade the default instance too, but when I try that I get a similar error message. ... For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. ...
    (microsoft.public.windows.server.sbs)
Loading