Unselect All

[kupokev]

This is for the schema compare extension.

I have been working with SSDT for quite a while and one thing that always drove me crazy is I could never do a "Unselect All". Sometimes when I am doing a schema compare, I don't want to move all the changes, or maybe I just want to compare a few tables.

The dependent table logic that is built in is super useful, but it is stopping me from unselecting more than a couple items before it reselects the item. this does not give me enough time to unselect all the tables I do not want to update.

Ideally, there would be an option to "Unselect All" so I can choose which objects I want to update. Then use the dependent table logic to tell me what other tables need updated as well in order to be able to update the selected object.

[7even7]

This is indeed a needed feature. We have a legacy DB that is currently in progress to be greenfielded. But until everything is checked and cleaned up, we have a situation where I must deselect hundreds of objects from compare results in order to make a simple table update. This of course is not a viable possibility, so I have to use VS data tools, where I can deselect per action group (add, delete, change).

Multiselect with shift and ctrl should also be allowed operations.

[jaypaige]

Yes, please build this!

[gumbarros]

Please, we have a legacy DB too and it's horrible to unselect one by one

[alexszasz]

Absolutely need this!

[martinleo]

Will we make it to the third anniversary? 😵

[el1jaC]

Yeah pls need this! It's very uncomfortable when I have to prepare a deploy script selecting table, procedure, views or whatever one by one!

[FaigBagirov]

I can't believe that there's no such feature in the Schema Compare. This is crazy... It's like making a car without a steering wheel...

This small script will help those who struggle as I did because of lack of this feature: You need to click on the very first checkbox, then open this script. It will Alt+Tab back to the azure data tools and deselect all checkboxes in few seconds, in she Allah.

#Load the System.Windows.Forms assembly
Add-Type -AssemblyName System.Windows.Forms

#Define the key codes for Alt, Tab, Down and Space
$alt = [System.Windows.Forms.Keys]::Alt
$tab = [System.Windows.Forms.Keys]::Tab
$down = [System.Windows.Forms.Keys]::Down
$space = [System.Windows.Forms.Keys]::Space

#Create a SendKeys object
$sendkeys = New-Object -ComObject WScript.Shell

#Send the Alt+Tab key combination
$sendkeys.SendKeys("%{TAB}")

#Wait for 1 second
Start-Sleep -m 1000



#Loop 500 times
for ($i = 0; $i -lt 500; $i++) {
    # Send the Space key
    $sendkeys.SendKeys("{DOWN}")
    Start-Sleep -m 2
    $sendkeys.SendKeys(" ") 
}