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/141 ... nstead-of-