azuredatastudio icon indicating copy to clipboard operation
azuredatastudio copied to clipboard

Schema Compare - include/exclude multiple objects/rows

Open filipalai opened this issue 3 years ago • 3 comments

It would be extremely convenient to be able to select multiple rows in the Schema Compare, and right-click and choose to Exclude or Include them (just like in Visual Studio). Also, the feature in Visual Studio where Added, Deleted and Changed object are grouped is very handy - as well as being able to right-click each group and select Exclude/Include.

filipalai avatar Apr 28 '22 08:04 filipalai

for me, this is the main reason why im not using ADS anymore. I dont want to manually uncheck (exclude) hundreds of objects.

indexample avatar Sep 12 '22 09:09 indexample

for me, this is the main reason why im not using ADS anymore. I dont want to manually uncheck (exclude) hundreds of objects.

@indexample What is the alternative tool you are using now? (for comparing schemas)

tecodan avatar Sep 14 '22 03:09 tecodan

Visual Studio has a schema compare option (or extension).

image

there its easy to (un)check all, or all in the group Deletes, Changes, New objects, save configurations to a .scmp file that remembers all checks image

indexample avatar Sep 14 '22 07:09 indexample

Would be extremely useful...

okarika avatar Apr 03 '23 12:04 okarika

Please add 2 buttons « Select all » « unselect all »

dp33Fr avatar Apr 16 '23 11:04 dp33Fr

Indeed, adding just the Select All / Unselect All buttons would save a huge amount of hassle already.

The combination of:

  • a large amount of changes
  • users only wanting to apply a small subset of changes
  • the Schema Compare tool asynchronously in the background trying to Re-select any items that are dependencies of items that are not even in the subset of interest (because users are still busy trying to deselect everything)

makes for a very frustrating experience, feels like playing whack-a-mole at times :(.

Just being able to start from a completely unselected state would allow users to add the changes they want to apply and wait for the dependency manager to reselect anything that is required for the subset without getting in the way.

ltjkoomen avatar Nov 16 '23 15:11 ltjkoomen