Red Gate forums :: View topic - Schema owned by a role - Deployment Error
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Schema owned by a role - Deployment Error

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ohm



Joined: 10 May 2012
Posts: 1

PostPosted: Thu May 10, 2012 5:45 am    Post subject: Schema owned by a role - Deployment Error Reply with quote

When trying to deploy a database with SQL Compare to a new database and the source database contains a schema that is owned by a role an error can occur.

The way deployment scripts are ordered schemas are created before roles, so in the case of the above the following error will occur:

Code:
[15151] Cannot find the user 'TEST_SCHEMA', because it does not exist or you do not have permission.
CREATE SCHEMA failed due to previous errors.

The following SQL command caused the error:

CREATE SCHEMA [TEST_SCHEMA]
AUTHORIZATION [TEST_SCHEMA]


This is obviously because your role hasn't yet had the chance to be deployed and hence your script will fail. Editing the script manually to create the role before said schema will allow the deployment through without fault.

Can the developers please check for schemas owned by roles and rearrange how the deployment scripts are created for these cases?

Thanks!
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Mon May 14, 2012 10:15 am    Post subject: Reply with quote

Hi Ohm

Thank you for your post into the forum.

I have added the details of this forum post to an existing Bug Report reference SC-5584. We hope to have a fix for this particular bug in the next version SQL Compare V10.2. Sadly I do not have a release date at this time.

I will update this forum post when I receive further information.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Wed May 16, 2012 6:16 pm    Post subject: Reply with quote

Hi Ohm

Quick update for you. Sadly your bug SC-5584, did not make into SQL Compare V10.2 released earlier today. I am sorry if I raised your expectations on fixing this problem.

Hopefully this bug will be fixed in the near future.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Wed Jun 06, 2012 7:49 pm    Post subject: Reply with quote

Hi Ohm

You will be please to know that the bug you reported to us in this forum thread which resulted in Bug report SC-5584 has now been resolved in SQL Compare V10.2.0.916.

Please use this LINK to download.

Can you please download and upgrade to confirm that this problem is resolved in your environment.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group