Moving the Prism Deploy Server and Channel Database from one Machine to Another Machine

New Boundary Support
Install/Upgrade - General Information

The information in this article applies to the following products:

• Prism Deploy 7.0 and above


There may be situations that require you to move both the Prism Deploy Channel Server and the Prism Deploy Channel database from a machine to a different machine. For example, you are retiring a server and want to move your entire Prism installation to a new server.

If you are moving just your Prism Deploy Channel Server, please use the following Article instead:

If you are moving just your Prism Deploy Channel database server (MSDE or SQL), please use the following Article instead:


  • Keep in mind that there is a difference between the Prism Deploy Channel Server and the Prism Deploy Channel database server. The Prism Deploy Channel Server is the center of Prism Deploy operations. It manages communication between the Prism Deploy Console, the Prism Deploy clients and the Prism Deploy Channel database. The Prism Deploy Channel database server (MSDE or SQL) stores data about computers, groups and tasks, etc. within the Channel.
  • These two components are not required to be on the same system, but this Article assumes that they are both installed on the same machine and you wish to move them both to a new machine.
  • It is beyond the scope of this document to explain all the options and considerations for backing up, restoring, moving and modifying databases. Please refer to “Books Online” if you’re using SQL Server. If you’re using MSDE, please refer to this web page as a starting point:;en-us;325003.

·        SQL based screen shots were taken of SQL Express 2008 R2


  1. To begin the process of moving your Prism Deploy Channel Server to another machine, you first should change all of your Clients' subscription information to point to the new server.
  2. From the Prism Console, choose Computers | Create Subscription File.
  3. Click the Settings button and then the Server tab.
  4. Change the name from the current Prism Server to the name of the machine that will host your moved Prism Server and click OK twice.
  5. Save the file as an executable in a location visible to the target machines.  Ex. \\server\share
  6. Create a Command that installs this new Subscription File.
  7. Edit the new tasks properties and uncheck the "Wait for completion" box on the Command tab.
  8. Assign this Task to all of your machines.  When the Task runs, the Client will stop polling your current Prism Server and begin to poll the machine that will host your new Prism Server.
  9. Repeat steps 1 trough 8 for all of your channels on this Prism Server.  NOTE: Only move to step 10 when all of your machines have successfully run the Task.
  10. On your original Prism Deploy Channel Server, launch the Prism Deploy Setup and choose Remove, press Next >.
  11. ALTERNATLY: If you wish to leave the Prism Editor and Prism Console on this machine, choose Modify on screen from Step 11, press Next >, and then unselect the Channel Server, press Next >.
  12.   It is necessary to complete either Step 10 or Step 11. This disconnects the Channel database within the SQL Server, thus enabling it to be used with a new Prism Deploy Channel Server.
  13.  On your SQL Server, back up your existing database(s). Prism Deploy Channel databases often use the same name as the Channel name with “_PD” appended to the end. This Article assumes the channel is named “Production” and the channel database is named “Production_PD”.
  14. You can use SQL Server Management Studio, 3rd party SQL management tools, or MSDE command-line options (osql.exe) to perform the backup. Our screenshots show the steps in Management Studio; the command-line options for MSDE can be seen in the Note at the bottom of this article.
  15. Right-click the Database... and select Tasks, and then Backup….
  16. Give the backup a name and click OK. (Make sure that the location and folder structure already exist.)
  17.  Click OK on the screen from step 15 to start the backup.
  18.  Repeat steps 14 through 17 for each channel that you wish to move.
  19.  Install the Prism Deploy Channel Server (and Administrator Console, if desired) on the new server system you plan to use.
  20.  When configuring your Prism Deploy Channel Server, be sure to associate it with the new or existing SQL instance that is the one on your new server.
  21.  After the Prism Deploy setup completes, move the backup file(s) that you create in step 14 through 17 to your new SQL Server (preferably into the same folder structure).
  22.  On the new server, launch your SQL management tool to restore the database(s).
  23.  Under “Source for restore” chose “From Device” and click the “…” button.
  24.  Click the Add… button.
  25.  Select the backup file that you created in step 21 and click OK.
  26.  Click through two more OKs.
  27.  After the restore completes, you will get the message:
  28.  Repeat steps 22 through 27 for each channel that you moved.
  29.  Right click on the Prism Deploy Channel Manager in the system tray ()and choose Connect Channel…
  30.  Choose the authentication method and click Next ->.
  31.  Select the channel that you restored and click Next -> and then Finish. Repeat for each channel that you moved.
  32.  Launch the Prism Deploy Console if the “Select a channel you wish to manage” window is not still open as a result of Step 21.
  33.  Click the Find… button.
  34.   Type in “<this>” and click Next -> to see all channels that have been connected to the local Prism Deploy Channel Server.
  35.  Select that channel that you moved and click Finish.
  36.  Repeat steps 34 through 36 for each channel that you moved.



NOTE: If you are using osql.exe (provided with all version of SQL) instead of Enterprise Manager, the following steps can be substituted:


Steps 15 through 18 can be substituted with the following commands:

1. osql –S %computername%\sw_deploy_server –E

2.  Within osql type:

a. BACKUP DATABASE Production_PD TO DISK = 'C:\Production_PD.bak'

b. GO

Steps 23 through 28 can be substituted with the following commands:

1. osql –S %computername%\sw_deploy_server –E

2. Within osql type:

a. RESTORE DATABASE Production_PD FROM DISK = 'C:\Production_PD.bak'

b. GO

These steps assume that you are using the default MSDE instance that is created via the Prism Deploy installation. If you manually installed MSDE or SQL Server before installing Prism Deploy, please replace %computername%\sw_deploy_server with the name of the instance that you are using.

Also In This Category

On a scale of 1-5, please rate the helpfulness of this article

Not Helpful
Very Helpful
Optionally provide your comments to help us improve this article...

Thank you for your feedback!

Add Your Comments
Email Address:
RadEditor - HTML WYSIWYG Editor. MS Word-like content editing experience thanks to a rich set of formatting tools, dropdowns, dialogs, system modules and built-in spell-check.
RadEditor's components - toolbar, content area, modes and modules
Toolbar's wrapper  
Content area wrapper
RadEditor's bottom area: Design, Html and Preview modes, Statistics module and resize handle.
It contains RadEditor's Modes/views (HTML, Design and Preview), Statistics and Resizer
Editor Mode buttonsStatistics moduleEditor resizer
RadEditor's Modules - special tools used to provide extra information such as Tag Inspector, Real Time HTML Viewer, Tag Properties and other.
Verification Code:
Last Modified: 12 Years Ago
Last Modified By: New Boundary Support
Article not rated yet.
Article has been viewed 14.1K times.
Customer Support Software By InstantKB 2015-2
Execution: 0.000. 10 queries. Compression Disabled.