Feature request: WHERE clause when linking static data

[Kasper Bengtsen]

SQL Source Control can be used as the tool for implementing continuous integration of the database schema (using the command line tool for SQL Compare to compare the source control repository vs. the integration database).
However SQL Source Control will not be entirely useful in doing the same on the data side, as long as a WHERE clause cannot be assigned to the linking of static data (it is possible to assign one in the SQL Data Compare tool, but developers don't generally need access to that).

Including this feature will (in our case anyway) make it possible to go "full circle" in using RedGate tools for continuous integration of the database schema and data.

Example.: Only some reference data in a DocumentTemplate table needs to go into the integration database, not the 100.000 test data rows created by the developers. Translating into, for example "WHERE DocumentType = 1" or something of that kind.

[eddie davis]

Thank you for your post into the forum.

I have submitted this feature request on your behalf. The reference number for the feature request submitted is SOC-3054.

I cannot guarantee the success of the request submitted. Or if approval is given, what future version of the product it will appear in.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com

[David Atkinson]

Kasper,

We do hope to add this feature at some point in a later version. In the meantime please just set the static data tables in SQL Source Control to be those tables that *exclusively* have static data. For those which have a mix, manage these outside of the tool.

Apologies for the inconvenience.

David Atkinson
Product Manager
Red Gate Software

[Kasper Bengtsen]

Thanks for the quick reply

Sounds great

The improvements in the source control plugin (like the latest option to filter out objects) is really helpful in implementing continuous integration without having to do too many manual tasks.

Implementing this feature request will eliminate another one of those tasks.

[David Atkinson]

Yes, we're really focusing on building a strong continuous integration story. At the moment you may have noticed that the filter options you set up in SQL Source Control aren't picked up by SQL Compare. This will be fixed in the EA build due out next week.

And of course the ability to add custom change scripts with the upcoming migrations feature will further strengthen continuous integration.

David