Skip to content

Settings and activity

2 results found

  1. 33 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Graham Clark supported this idea  · 
  2. 530 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    under review  ·  Kendra responded

    Thanks for this suggestion and for the many comments and upvotes. I realize that this is a pain point.

    I have a few shorter-term workarounds to summarize as well as some information on the longer roadmap in this update. I know these shorter-term workarounds aren’t perfect (I summarize the pros and cons), but I’m posting them as they may help a few folks.

    Workaround 1) When data changes to static data need to be made, use a “relink the table” pattern
    One can “cleanly rescript” a static data table in SQL Source Control by:

    • Unlinking the static data table
    • Committing
    • Relinking the static data table
    • Committing

    Pro: This works with the GUI and requires no special knowledge or comfort with TSQL. This may help folks with just a few static data tables.
    Con: This requires extra steps and results in extra commits in the history, which I realize can…

    An error occurred while saving the comment
    Graham Clark commented  · 

    This is the same as http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/2024519-make-sql-data-easier-to-merge so should be merged. Hopefully the order of the requests won't make that difficult!

    An error occurred while saving the comment
    Graham Clark commented  · 

    This is the same as http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/3082371-diffs-when-ssc-changes-order-of-rows-in-static-tab so should be merged. Hopefully the order of the requests won't make that difficult!

    Graham Clark supported this idea  ·