deploy script - drop and create only

Forum for users of SQL Compare schema synchronization utility

deploy script - drop and create only

Postby ricva » Mon Oct 29, 2012 5:46 pm

For our database we reload data and do not need to transfer data between a new table schema and the old. Is there a way to set the deployment script to just generate a drop and create statement instead of the "create temp table, copy data, drop and rename".

Ric VA
Posts: 1
Joined: Tue Aug 07, 2012 4:17 pm

Postby Manfred.Castro » Wed Oct 31, 2012 7:11 pm

There is the option:
Use DROP and CREATE instead of ALTER
When this option is selected, SQL Compare replaces ALTER statements in the deployment script with DROP and CREATE statements for the following objects:
Stored Procedures
Extended Properties
DDL Triggers
DML Triggers
This setting does not however apply to Tables
You can request features for this product in our uservoice forums. ... uggestions
These forums are monitored by our developers and allow our users to request features and vote on them.
If a request receives significant support the feature may be included in a future release.
Manfred Castro
Product Support
Red Gate Software
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests