I am looking into the RedGate SQL Toolbelt to allow for full database CI and am comfortable with how the tools can facilitate my needs for schema and static data.
However, there will be a certain amount of data in other tables that I would like to source control and use within my CI. These tables may have a million records with only a handful of records needing to be in source control. The database design means that this data cannot go in a separate table that can then be source controlled.
A good example may be a Users table where you want to source control the Admin or System user so it can be part of your CI but want to exclude any real users.
RedGate have had a request for filtered static data around since mid-2011 and I was wondering if anyone had devised a sensible method for getting around this limitation?