Skip to content
← SQL Change Automation

How can we improve SQL Change Automation?

SQL Change Automation

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Visual Studio Improvements

I would like to see a few filters added that would make working with the Main table of objects easier.
Filter by Object type: Table, stored procedure, etc
Filter Object name: Ability to type / paste in a partial name.
Filter to show tables with data. With data, without data, all

I have a project with 575 objects and growing. My main reason for this is working with tables that include data. It is hard to tell which tables include table data. We need a quick reference to see which ones are under source control. As I go through and assign new tables to include table data it is hard to scroll through the giant list and pick the correct objects.

Thanks

9 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Andy Cater shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminKendra (Admin, Redgate) commented  ·   ·  Report

    Hi Andy, thanks for this suggestion. Apologies on the delayed response.

    We do have the ability to filter by object name in the SQL Change Automation plugin in Visual Studio. The feature is a bit hidden -- you simply begin typing when you are on the page where you would import/generate migrations. A video of this feature is here: https://youtu.be/3QmjVuZTBBI

    Since you made this request, we have added a plugin for SQL Change Automation for SQL Server Management Studio. We have recently also added a filter option to this plugin, and it is also based on object name. A video of that feature is here: https://youtu.be/ch9lcRjPwL4

    We have not implemented filters by object type, or by whether a table contains static data.

    User voice doesn't give me the option to mark this as "partially completed", so I am going to go ahead and mark this as "completed", as I am hoping that the object name filter satisfies most of this need, and I believe the 'Data' tab on the SSMS plugin may help make it easier for users to quickly refer to and see which tables have static data checked in. Please do continue to give us feedback if this continues to be painful with these features available.