Red Gate forums :: View topic - Blind SQL Comparison against Low Privilege database.
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

Blind SQL Comparison against Low Privilege database.

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



Joined: 15 Jan 2013
Posts: 1

PostPosted: Tue Jan 15, 2013 8:12 pm    Post subject: Blind SQL Comparison against Low Privilege database. Reply with quote

I work at a company that has highly restricted database environments. We are trying to introduce Red Gate (the developer bundle) as part of our process.

So it works pretty good at first because we (the developers) have full access to Dev and Test environments.

However when our database code gets to the Stage environment we are in a pickle. The DBA's (who have access) are not in tune (and cannot be due to other bureaucratic reasons) with what objects we need synchronized, but we (the developers) cannot generate working scripts against Stage to give to the DBA's.

I know the root problem here is lack of permission, but due to the industry this company is in they take security very seriously and do not want to give any permissions except where absolutely necessary.

Here is what I have tried that almost worked:

1) I setup a blank database to compare against
2) I chose Behavior "Use DROP and CREATE instead of ALTER"
3) Then I chose appropriate items and it generated a script that worked for the FIRST time

When I tried to repeat the process, what happened is that the tables were not dropped the 2nd time (as described in the help text) And my newest table schema was not applied.

Is it possible to include tables in the "Use DROP and CREATE instead of ALTER" feature? The caveat is that data is destroyed... In my case I was coming in behind with a Data Compare script and filling in the data after.

Edit: I created this http://redgate.uservoice.com/forums/141379-sql-compare-feature-suggestions/suggestions/3554275-include-tables-in-use-drop-and-create-instead-of-
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Thu Jan 17, 2013 10:23 pm    Post subject: Reply with quote

This would be considered a feature request.
Under normal circumstances I would recommend that you request this feature in our uservoice forums.
But it appears you have already done so.
Hopefully the request recieves enough votes to be considered in a future release.
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
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