Settings and activity

  1. 32 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  SQL Compare  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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. 96 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  SQL Compare  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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