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:
We have several tables with static data that has to be laid down on install, but devs may add additional rows during testing that we DON'T want to ship. Would be nice to have a WHERE clause to filter out rows we don't/do want.
Klaus Espernberger commented
We also would like to use Source Control for data content.
But Link Static Data for the whole table is way too much of data.
We would need this with a where clause to be selective.
We do have many tables that contain both static and user data.
So please put this onto the development Goals.
Jorge Salazar commented
Almost 2 and a half years of the initial request and still no solution on this item?
We use SQL Source Control 18.104.22.1682 and there is no solution on this...
Is really that hard to implement?
Timothy Bussmann commented
We have a scenario where we have table maintenance screens in a user interface to allow the user to add/modify/delete lookup type values. As part of our application we provide a number of lookup values that are system defined and cannot be modified. We would like to be able to source control the system defined values, but also allow for user defined values to be unaffected. It does not make sense for us to use a separate table for the user defined lookup values because that would complicate the data schema and application design. It would help us a lot if we were able to source control static data that is filtered by a where clause (e.g. IsSystemDefined = 1 in our case).
Kasper B commented
Respecting a WHERE clause would eliminate the use of a view, so that is what I would prefer.
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 Ferreri commented
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.