deploy script - drop and create only

Compares and synchronizes SQL Server databases, backups and scripts.

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".

Thanks
Ric VA
ricva
 
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:
Views
Stored Procedures
Functions
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.
http://redgate.uservoice.com/forums/141 ... 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
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Compare 10

Who is online

Users browsing this forum: sanwal and 0 guests