Skip to content
← Customer Feedback for Redgate

Settings and activity

2 results found

  1. Include tables in "use drop and create instead of alter" comparison behavior

    32 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…)
    4 comments  ·  SQL Compare  ·  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
    An error occurred while saving the comment
    Ram Sola commented  · 

    We can always have extra option to drop and create tables instead of alter.
    There are scenarios where we want to move new data to prod tables and flush out existing data and don't want to alter tables as we need columns in the order we have it in our development database and also for data transfer using partition switch in/out which requires similar table structure in both target and source.

    I don't think it will harm any process unless user especially selects this option during deployment.

    Ram Sola supported this idea  · 

  2. Add a Rollback Script Save option for both SQL Compare & Data Compare

    105 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…)
    4 comments  ·  SQL Compare  ·  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
    An error occurred while saving the comment
    Ram Sola commented  · 

    Currently there is no functionality of creating rollback script when deployment script is generated using SQL compare. It will be really helpful if we can have rollback script as well when we are moving new changes to target we should be able to rollback them using script and not using backup or snapshot