Settings and activity

  1. 524 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    36 comments  ·  SQL Source Control » Static Data  ·  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)
    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
    Paul Stephenson commented  · 

    Good spot Graham. I've merged the two suggestions now.

  2. 1 vote
    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)
    An error occurred while saving the comment
    Paul Stephenson commented  · 

    Hi Rusty, the checkbox at the top of the column of checkboxes acts as a global switch. Does this do what you want?

  3. 215 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    36 comments  ·  SQL Source Control  ·  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
    Paul Stephenson commented  · 

    @Anonymous: Are you using SQL Connect at the moment for connecting to a Visual Studio database project? Have you already tried using SQL Source Control instead? If so, what issues (if any) remain before you would be happy to use SQL Source Control as your primary tool for interacting with the VS database project?

    To move the support out of beta status we would like feedback to confirm that it meets your needs in real-world situations -- and if it doesn't, what those limitations are so that we can look at addressing them.

    An error occurred while saving the comment
    Paul Stephenson commented  · 

    @Peter: Improving support for branches in SQL Source Control is high up on our priority list and we'll be looking at it soon. For the moment, a workaround is to switch branches using your normal source control tool. Then in SQL Source Control, do a Get Latest to pick up differences in the new branch. After that, on the Commit Changes tab, right-click and Undo Changes. These steps should make the database match whatever is in the filesystem's new branch.

  4. 6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Prompt » Find invalid objects  ·  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
    Paul Stephenson commented  · 

    As a workaround, you can copy and paste the list into a spreadsheet. Click on a result, press Ctrl+A or Shift-click to select them all and then right-click and Copy. Paste into your favourite spreadsheet application -- SQL Prompt also adds the database name in case you want to add rows for more than one database in the same sheet.