Skip to content
← Customer Feedback for Redgate

Settings and activity

1 result found

  1. Add "if exists...drop" option for programability objects

    27 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  SQL Source Control  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    AdminRedgate Administrator (Admin, Redgate) responded

    For now, you may be able to use a batch file that executes SQL and drops the objects you want re-created before using the SQL Compare Command Line API. Since the objects are dropped, the synch script will generate CREATE scripts instead of alter.

    If you wanted to create everything from scratch, you could drop and recreate the database, which would generate all CREATE scripts.

    I hope this helps for now.

    anonymous shared this idea  ·