How to move Printer Queues to a newly added Pharos Print Server.

Problem:

How to move Printer Queues to a new Print Server

Applies To:

Printer Queue / Pharos Print Server

Solution:

The printer queues can be moved manually by running a SQL script.

Steps to run the SQL script:

1. Install the Pharos Print Server on the new Server machine.

2. Run the queries against SQL/MSDE Database to modify the server_ID field in the Printers table.

   - First determine the ID for the new server by running the following query:

   use pharos

   select * from servers

   - Next run the query to update the server_id field:

   update printers

   set server_id = '1'

   where printer_id = '2'

3. Create printers with identical names on the new Pharos Print Server.

Following the steps above will allow you to simply move the Printers from one server to another and keep all the prior transactions.