How can we help you today? How can we help you today?

deploy script - drop and create only

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
ricva
0

Comments

1 comment

Sort by
  • Manfred.Castro
    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
    0

Add comment

Please sign in to leave a comment.