Link Static Data with filter?

Dan Guzman

I have tables that contain a mix of static data and user data. Using the stand-alone SQL Data Compare tool, I can specify filter criteria so that only static rows are included. However, I can't find a similar option in SQL Source Control to include only static data. Does such a filter option exist in this tool?

Rob C

Hi Dan,

Unfortunately there's no functionality at present to filter the data within a table. The only static data linking option is to link all the data within a table.

If you'd like to suggest it as a feature then please post it on our User Voice site. You can also vote for suggestions that other users have made. We regularly monitor this page and it is something we use for information when the developers are trying to decide what new features to work on.

Thanks.

Dan Guzman

Thanks. I'll submit feedback.