Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-06 : 08:21:08
|
| Sanjeev writes "All :I have a remedy setup installed on the SQL Standard 2K.Now, the need has arise to replace the SQL 2K standard with SQL 2K Enterprise. The SQL Box will remain the same.Will it be a upgrade from SQL 2K standard to SQL 2K enterprise or it will be a re-installaion of SQL server with Enterprise Edition ?Anticipating a very quick response on this.Thanks in advance,Sanjeev Verma" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-11-06 : 12:09:02
|
| I believe you can just upgrade. -Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-06 : 12:31:25
|
| You could install another instance of SQL Server so that you have both std and ent editions. Then just detach/attach or backup/restore to move the database over. You could also uninstall the standard edition, then install enterprise edition if you want to remain with the default instance (some people are anal about these kinds of things), just make sure you do backup beforehand.Tara |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-11-06 : 12:38:21
|
What I am saying is you don't need to uninstall/reinstall.From BOL:quote:
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 Insert the Microsoft® SQL Server 2000™ 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.Select SQL Server 2000 Components, select Install Database Server, and then setup prepares the SQL Server Installation Wizard. At the Welcome screen, click Next.In Computer Name dialog box, select Local Computer or Remote computer.In the Installation Selection dialog box, click Upgrade, Remove, or Add Components to an existing instance of SQL Server, and then click Next.In the Instance Name dialog box, click Next.In the Existing Installation dialog box, click Upgrade your existing installation, and then click Next.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.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.When you are finished specifying options, in the Start Copying Files dialog box, click Next.In the Setup Complete dialog box, click Yes, I want to restart my computer now, and then click Finish to complete the edition upgrade.
-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-06 : 12:43:29
|
| Right, I was just letting him know the options.Tara |
|
|
|
|
|
|
|
|
SQL 2K Standard to SQL 2K enterprise - upgrade or reinstall