







SQL Server Setup Help | |
How to: Migrate Notification Services Instances to a Higher Edition (SQL Server Management Studio) | |
![]() |
![]() ![]() |
Upgrading SQL Server Components > Upgrading SQL Server Components How-to Topics > Migrating Notification Services How-to Topics > |
If you create an instance of Notification Services using a lower edition of Microsoft SQL Server 2005, such as Standard Edition, and later want to upgrade to a higher edition of SQL Server, such as Enterprise Edition, you must upgrade the instance of Notification Services to the higher edition. The following procedure shows how to migrate a Notification Services instance to a higher edition using SQL Server Management Studio.
![]() |
---|
Instances of Notification Services can be deployed in many different configurations. Use the following procedure as a guideline for developing and testing your own migration procedures. |
To upgrade to a higher edition of Notification Services
-
In SQL Server Management Studio Object Explorer, expand Notification Services.
-
Right-click the instance and select Disable.
-
Right-click the instance you are migrating and select Stop.
-
Close SQL Server Management Studio and any other open applications.
-
On each server where the instance of Notification Services is installed, use Setup to upgrade Notification Services to the higher edition.
-
In SQL Server Management Studio Object Explorer, expand Notification Services.
-
In Object Explorer, right-click the instance, point to Tasks, and then select Upgrade. This upgrades the edition and version numbers in the instance and application databases.
-
Right-click the instance and select Update.
Provide the requested information in the Update dialog.
Make sure to select Enable instance after it is updated.
-
Right-click the instance and select Start.