Running SQL Compare i get this message any ideas

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Running SQL Compare i get this message any ideas

Postby lkalman@financemgr.com » Wed Apr 11, 2012 2:15 pm

Msg 2760, Level 16, State 1, Line 1
The specified schema name "PR" either does not exist or you do not have permission to use it.
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

Postby eddie davis » Fri Apr 13, 2012 3:42 pm

Hi, thank you for your post into the forum.

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.

This knowledge base article contains the necessary information regarding the security permissions required.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby lkalman@financemgr.com » Fri Apr 13, 2012 3:45 pm

I am a sysadmin
I am running a schema compare and its failing on the script
Could it be a dependecy not being run prior.
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

Postby eddie davis » Fri Apr 13, 2012 5:28 pm

Thank you for your reply.

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.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby lkalman@financemgr.com » Fri Apr 13, 2012 6:07 pm

I have all dependencies checked and all objects selected.
thats why i am confused
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

Postby eddie davis » Mon Apr 16, 2012 10:00 am

Thank you for your reply.

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?

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest