SQL Server edition upgrade is a process in which an SQL Server instance will be upgraded from one edition to another.
To find the supported paths for Version and Edition Upgrades, follow the below link to make sure to choose the right upgrade path.
http://msdn.microsoft.com/en-IN/library/ms143393.aspx
The steps in this post, shows the procedure to upgrade SQL Server 2008 R2 Standard Edition to Enterprise Edition.
Before the Upgrade:
Edition Upgrade Process:
To find the supported paths for Version and Edition Upgrades, follow the below link to make sure to choose the right upgrade path.
http://msdn.microsoft.com/en-IN/library/ms143393.aspx
The steps in this post, shows the procedure to upgrade SQL Server 2008 R2 Standard Edition to Enterprise Edition.
Before the Upgrade:
- Insert the Installation media and Run "setup.exe"
- Go to "Maintenance" page and choose "Edition Upgrade"
- This will now check and verify few rules which help in the smooth setup process. Click "Ok" in this screen
- On clicking ok, the setup will now verify few more rules. Click "Next" in this screen
- Enter the Product Key and click "Next"
- Read the License Terms and accept it and click "Next"
- Select the Instance that needs to be upgraded and Click "Next"
- On clicking next in previous step, the setup verifies few rules related to upgrade, based on the result, fix any issues reported or click "Next"
- In the summary screen, verify the actions, if any changes required click "Back" else click "Upgrade"
- Once the Upgrade is completed, Click "Close"
After Upgrade:
2 comments:
Nice Post i have read this article and if I can I would like to suggest some cool tips or advice and perhaps you could write future articles that reference this article. I want to know more!
Data Analytics Course in Gurgaon
This is an informative and knowledgeable article. therefore, I would like to thank you for your effort in writing this article.
Data Scientist Course in Chandigarh
Post a Comment