Red Gate forums :: View topic - Feature request: WHERE clause when linking static data
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

Feature request: WHERE clause when linking static data

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Kasper Bengtsen



Joined: 13 Jul 2011
Posts: 6

PostPosted: Thu Sep 15, 2011 10:39 am    Post subject: Feature request: WHERE clause when linking static data Reply with quote

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. Smile Translating into, for example "WHERE DocumentType = 1" or something of that kind.
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Mon Sep 19, 2011 10:39 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Mon Sep 19, 2011 11:45 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Kasper Bengtsen



Joined: 13 Jul 2011
Posts: 6

PostPosted: Fri Sep 30, 2011 12:08 pm    Post subject: Reply with quote

Thanks for the quick reply

Sounds great Very Happy

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. Smile
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Fri Sep 30, 2011 1:14 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group