Migrating Pharos database from one SQL Server to another.

Question:

How can I migrate the Uniprint Database from one SQL Server to a different SQL Server?

Answer:

By following the steps below.

1. Stop all Pharos Services.

2. In SQL Enterprise Manager, go to Microsoft SQL Servers > SQL Server Group > [SQL Server] > Databases.

3. Right Click on the Pharos database, select All Tasks > Detach Database. Click OK when prompted.

4. Copy the file pharos_data.mdf from the SQL data folder of the original server to the SQL data folder of the new server.

5. You need to add the SQL 'Pharos' user and set the password to the data found in the following registry item on the Pharos server.
   HKLM\Software\Wow6432Node\Pharos\Database Server\Database\Password

6. On the new server within SQL Enterprise Manager go to Microsoft SQL Servers > SQL Server Group > [SQL Server] > Databases.

7. Right click on Database and select All Tasks > Attach Database.

8. Click the '...' button and browse for the file pharos_data.mdf in the SQL data folder. Select it and click OK.

9. Ensure that the field "Attach as" is pharos and the field "Specify database owner" is pharos. Click OK, click Yes, then click OK and the database should be attached.

10. On the Pharos Server you need to modify the following registry entry so it will know what server to connect with.

    HKLM\Software\Wow6432Node\Pharos\Database Server\Database\Server Name

11. On your Pharos server start your Pharos services ( or restart the machine ) and it should be up and running. Open Pharos Administrator to confirm everything is as you expect.