The error message you are experiencing is from SQL Server and indicates that the object being compared either does not exist or the user running SQL Compare does not security permissions to access the object.

First I would check to ensure that you have a schema called "PR" in the data sources you are connected to.

Next ensure that the log-in account running SQL Compare has the necessary security permissions to view this "PR" schema and the objects within the "PR" schema.

OK so you are experiencing the reported problem when attempting to deploy or synchronize.

One possible reason could be that the script generated has not generated the "PR" schema before creating the objects for the schema.

The other possible reason is that the you are only deploying a subset of the database objects, including objects for the PR schema but did not select the PR schema for deployment and unchecked / disabled the "Deploy all dependencies (Recommended)" option in step 3 Review dependencies step of the deployment wizard.

Are you able to confirm from the deployment or synchronization script, that the "PR" schema is being created?

If the answer is yes, is the dependency order correct, the "PR" schema created before the objects for the "PR" schema?

A support call has been created for you, the call reference number is F0059220. If the answer to my second question is no, can you please send an e-mail to support@red-gate.com with the call reference number in the subject field of the e-mail and attach a copy of the deployment or synchronization script generated?