Q
Manage Learn to apply best practices and optimize your operations.

Upgrade SQL Server 7 to SQL Server 7 Enterprise Edition

We would like to upgrade a Microsoft SQL Server 7 to a Microsoft SQL Server 7 Enterprise Edition. Is this possible? I could not find anything useful in Microsoft Knowledge Base, and thought you might be able to help.
If you're willing to shut down the server, then this is not a particularly hard obstacle to overcome. The proper way to do this is to save your databases, uninstall Standard Edition, install Enterprise Edition and then recover all of the databases.

If taking a short cut is more your style, I actually recall going through the exercise of installing SQL Server 7 Enterprise Edition on an unused server long enough to compare it with SQL Server 7 Standard Edition. I discovered that there were only a few binaries that were different. Overwriting the Standard Edition binaries with the Enterprise Edition binaries upgraded the server (be sure to stop the SQL Server services first).

 


Do you have comments on this Ask the Expert Q&A? Let us know.
This was last published in July 2005

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close