What are the challenges you face when working across database platforms? Take the survey
Options

in SQL Data Compare it would be nice to have a way to select or unselect all columns.

How do you select or unselect all columns in SQL Data Compare.  It is extremely time consuming unchecking column 1 at a time!  A speed key to select and a speed key to unselect all would even be helpful.  
Tagged:

Answers

  • Options

    Hi @JimE

     

    Thanks for reaching out on the Redgate forums regarding your select/unselect query on SQL Data Compare.

     

    There are a few possible options that may help with this request.

     

    Include All/Exclude All are options in the Actions menu that quickly selects all columns and enables their checkboxes. Keyboard shortcuts are CTRL+I & CTRL+SHIFT+I respectively.

     

     

     

    You can also hold the SHIFT key when selecting columns to select a range of records between two records.

    Holding CTRL will allow you to click on individual columns to select. 

    Then use SPACEBAR to toggle all their checkboxes.

    When you have a range of records selected - clicking on the checkbox of one record will toggle that specific change for all records.

     This may be handy if you want to select a range of records to toggle.



     

    Right-Clicking within the differences window will also have some quick selections that may be of use too. 

    You can Include/Exclude all records or only checkboxes in Source Only, Different & Target Only columns

     

     

    Hopefully one or more of these quick-select options will be viable for your usage of Data Compare.

    Jon Kirkwood | Technical Support Engineer | Redgate Software
Sign In or Register to comment.