Synchronize only a subset of data
It would be tremendously useful if SQL Data Compare would support an option to pull only a subset of data from one database and synchronize it with another. This subset could be keyed off of one or more tables. With the current product the end user must construct their own where clauses in order to perform filtering. Furthermore, this filtering does not seem to check any foreign keys to make sure that related records are pulled. It would be very useful if there were an option to "instruct" SQL Data Compare to follow the foreign keys when filtering on one or more tables so that all related records in other tables are automatically pulled. This scenario is very useful when trying to create smaller development or test databases from very large datasets. It is very time consuming trying to build all the where clauses from scratch to make sure that related records are pulled when trying to grab only a subset of data.
Hi Michael, does this product generate random data or is it pulling actual data (a subset) from the source database?
Thanks for the quick response!
Forgot to add that an existing "freeware" product does something similar to this request, but is very complicated to use: it is called "Jailer": http://jailer.sourceforge.net