Suggest a new feature or enhancement; Ask a question...

← SQL Source Control

SQL Source Control Static Views (or Table Subsets using WHERE clause)

I would like the ability to source control a subset of a table (perhaps using a view).

I have inherited a database where lookup data is intermixed with user defined data. We reference the lookup data in the table using a code (VARCHAR) that is unique when another field is NULL, so it is possible to ensure that records are created/updated/deleted without concern for the primary key involved.

For more information, you can refer to this forum post:
http://www.red-gate.com/messageboard/viewtopic.php?p=50087

75 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Forgot password?
    Create a password
    I agree to the terms of service
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    JackAceJackAce shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Paul NearyPaul Neary shared a merged idea: Need to Filter Data by Row  ·   · 

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Forgot password?
      Create a password
      I agree to the terms of service
      Signed in as (Sign out)
      Close
      Close
      Submitting...
      • Kasper BKasper B commented  ·   ·  Flag as inappropriate

        Respecting a WHERE clause would eliminate the use of a view, so that is what I would prefer.

      • BarryKBarryK commented  ·   ·  Flag as inappropriate

        We just started using SQL Source Control 3 and it is a great feature. However the Link Static Data isn't much use without a where clause. We have numerous tables that contain both static and user data. Thanks for considering this feature.

      • Gabriele FerreriGabriele Ferreri commented  ·   ·  Flag as inappropriate

        We are actually using SQL Source Control 3 and it's important for us to be able to commit Static data using a where cause like in SQL Data Compare.
        Please add this feature.

      SQL Source Control: Static Data

      Feedback and Knowledge Base

      (thinking…)