Upgrading SQL 2000 Developer to Standard


    Sponsored Links


  • 1. ordinal not found
    Hi, Tried to upgrade Windows 2k adv server to Win server 2003 (enterprise), 1st trial failed. Win 2k adv server is brought back by using OS Emergency Repair Disk. Sql server 2000(sp3) can NOT run anymore. Got sqlmangr.exe Ordinal Not Found error Launching Enterprise Manager, Query analyzer, profiler as well as Service Manager lead the same error: The ordinal 29 could not be located in the dynamic link library odbcbcp.dll Client Network Utility and Server Network utility seem to be OK all the databases were backed up before OS upgrade. Can anybody advise me how to fix the problem? Is reinstallation of Sql server the only option? Many Thanks!
  • 2. Drive configuration
    The recommended configuration depends on lots of things and you can't go simply by the OS or the size of the drives. IS this going to be a high transaction server? If so you may want to think about adding another Mirrored drive array to place the logs on. -- Andrew J. Kelly SQL Server MVP "John Gidlund" < XXXX@XXXXX.COM > wrote in message news:082001c37881$fff66d00$ XXXX@XXXXX.COM ... > Does anyone know what drive configuration is recommended > when running SQL SVR 2000 on a Win 2000 server? IE: Disk > Mirroring, Raid, etc... We were planning on putting the > operating system on two 36 gig hard drive that are > mirrored and have the database on 4 72 gig hard drives > running raid 5.
  • 3. Full-Text Search not available
    I have the MSSearch Service Started and the Full Text Search is grayed out in Enterprise Manager. HELP!!!
  • 4. Sql server data lost on parallel install
    I am running windows 2000 and cannot get the server to boot to windows. I am considering a parallel install. Is it possible to pull my critical database information from the other installation and copy it to the new one somehow? Thanks,
  • 5. Optimization / Monitoring tool
    hi, Can anyone give me ref of monitoring and optimizing sqlserver,tool which can detect and advice ..or something like that. Thanks

Upgrading SQL 2000 Developer to Standard

Postby U2dpYnNvbg » Wed, 09 Feb 2005 04:57:03 GMT

I would like to put our SQL Server into production now.  It is currently 
setup on a Windows Server 2003 machine with SQL 2000 Developer.  I would like 
to simply install SQL 2000 Standard right over top of the developer edition 
and have it take over the job, so to speak.  I would like to keep all 
settings, databases, names, locations, security, etc.  Nothing will change 
except the edition of SQL.  Is there a procedure to do this?  Can I just put 
in the CD for standard and have it do an in-place upgrade or something like 

RE: Upgrading SQL 2000 Developer to Standard

Postby TmlrbyBQYW1ib3VrYXNbTVNd » Fri, 11 Feb 2005 15:37:02 GMT

You cannot upgrade the Developer edition to Standard, so one choice you have 
is to backup or detach all your databases, script out all system information, 
and then install standard edition with the same instance name and 
restore/attach your databases.

Thx, Niko
SQL Setup Test Team

RE: Upgrading SQL 2000 Developer to Standard

Postby U2dpYnNvbg » Sat, 12 Feb 2005 02:43:08 GMT

That sounds doable.  Can you point me to more information regarding the 
statement "script out all system information".

Similar Threads:

1.Upgrade SQL 2000 Personal to SQL 2000 Standard edition

I having problem with upgrading from SQL 2000 Personal to SQL 2000 Standard 
edition. When I try to upgrade the existing installation the following two 
options are masked and doesn't allow me to choose the option to upgrade.

- upgrade your existing installation.

- upgrade your existing installation to a clustered installation. 

I tried to stop the SQL server service and reboot the server. But still I am 
not able to upgrade. Could any one pour some idea on this as to what might 
happening and why it is not allowing me to upgrade?


2.Upgrading SQL 2000 Standard to SQL 2000 Enterprise

I'm planning to upgrade my SQL 2000 Standard to SQL 2000 Enterprise. Does
anyone know of any articles or any tips that would be useful?

Thanks in advance.
E Ortega

3.How to upgrade from SQL 2000 Standard to SQL 2000 Enterprise Editi

Quick question:

Is there a procesure to upgrade from SQL 2000 Standard to SQL 2000 
Enterprise Edition?  Thanks in advance. -Jim

4.Upgrade from SQL Server 2000 Standard to 2000 Enterprise


I am looking to upgrade from SQL Server 2000 Standard Edition to Enterprise 
Edition (2000). Our CRM software does not support 2005 versions as yet. Is 
there anything I should look-out for or be prepared for?

Is there anything I should do prior to starting the installation?



5.Upgrade from SQL Server 7 Developer to an official Standard edition

I think my SQL Server 7 installatation has been done using the MSDN
CDs and thus having the max amount of connectino hardcoded

"The maximum simultaneous user count of 10 licenses for this 'Standard
Edition' server has been exceeded. Additional licenses should be
obtained and installed or you should upgrade to a full version."

Is there a way to smoothly upgrade this SQL Server with a full
version? Any link to point? My system is installed and have a living
DB already :-(

Thanks for any help


PS I already have set the licensing mode to Per-Server and connections
are unlimited.

6. Upgrading from SQL 2005 developer to standard edition

7. Upgrade SQL 2005 Developer to Standard

8. SQL 2000 Standard and SQL 2005 Developer - Co-exist



Who is online

Users browsing this forum: No registered users and 24 guest