Share via


How to: Migrate Notification Services Instances to a Higher Edition (Command Prompt)

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 migrate the instance of Notification Services to match the database server. The following procedure shows how to migrate a Notification Services instance to a higher edition using command-prompt utilities.

Important

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

  1. On one server where the instance is registered, disable the instance:

    1. On the Start menu, point to All Programs\Microsoft SQL Server 2005\Configuration Tools, and then click Notification Services Command Prompt.
    2. Type the following command to disable the instance:
      nscontrol disable -nameinstanceName
  2. On each server where the instance is running, type the following command to stop the instance:

    **net stop NS$**instanceName

    If you are hosting the engine components in your own application, make sure the instance is not running.

  3. On each server where the instance of Notification Services is installed, upgrade Notification Services to the higher edition.

  4. On one server, type the following command to upgrade metadata in the databases:

    nscontrol upgrade -nameinstanceName-serverdatabaseServer

    Exact arguments vary depending on the security configuration.

  5. On one server, type the following command to update metadata in the databases:

    nscontrol update-inICFPath\ICFName.xml

    Exact arguments vary depending on the security configuration.

  6. On each server that runs an NS$instanceName Windows service, type the following to start the service:

    **net start NS$**instanceName

    If you are hosting the engine components in your own application, start the instance.

  7. On one server, type the following command to enable the instance:

    nscontrol enable -nameinstanceName

See Also

Tasks

Migrating Notification Services Instances to a Higher Edition of SQL Server 2005
How to: Migrate Notification Services Instances to a Higher Edition (SQL Server Management Studio)

Other Resources

nscontrol Utility

Help and Information

Getting SQL Server 2005 Assistance