Activity overview
Latest activity by DrData
[image] [image] [image] [image] [image] [image] Upon taking another look, I found that on the "Tables & Views" screen, all the way to the right, you must click "x of x columns" That will then open a window where you can uncheck specific columns. So obvious that I missed it! [image] / comments
Upon taking another look, I found that on the "Tables & Views" screen, all the way to the right, you must click "x of x columns" That will then open a window where you can uncheck specific columns....
How to select certain columns to NOT compare?
I have many tables that have an 'entry date' column that auto-fills based on when the record actually inserts into the table. When I am comparing tables, I only want to see records where any OTHER ...
I found this link in another post for another issue, but the newest version fixed the above problem for me in SSMS 18.12.1
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.0.31319.exe
/ comments
I found this link in another post for another issue, but the newest version fixed the above problem for me in SSMS 18.12.1
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.0...
Same issue here - worked perfect until this version. Hoping to see this fixed soon as this product saves us tons of time. / comments
Same issue here - worked perfect until this version. Hoping to see this fixed soon as this product saves us tons of time.
Kurt_M said:
Hi @DrData
The command line actually has more flexibility when it comes to filtering. I would suggest looking into the command line features if your license supports it.
You can find documentation about the command line here:
https://documentation.red-gate.com/sdc/using-the-command-line/examples-using-the-command-line
The specific options you would want to use are the following:
https://documentation.red-gate.com/sdc/using-the-command-line/command-line-syntax/switches-used-in-the-command-line#:~:text=Instead%20use%C2%A0/Include%3AAdditional-,/IncludeColumns,-Alias%3A%C2%A0/ic
https://documentation.red-gate.com/sdc/using-the-command-line/command-line-syntax/switches-used-in-the-command-line#:~:text=with%20unrelated%20names.-,/ExcludeColumns%3A%3Ctable%20or%20view%20name%3E%3A%3Cregular%20expression%3E,-Alias%3A%C2%A0/ec
Thanks - I was able to get it to work via command line. Hope to see in the GUI for less technical users in the future though. / comments
Kurt_M said:
Hi @DrData
The command line actually has more flexibility when it comes to filtering. I would suggest looking into the command line features if your license supports it.
You c...
Kurt_M said:
Hi @DrData
The command line actually has more flexibility when it comes to filtering. I would suggest looking into the command line features if your license supports it.
You can find documentation about the command line here:
https://documentation.red-gate.com/sdc/using-the-command-line/examples-using-the-command-line
The specific options you would want to use are the following:
https://documentation.red-gate.com/sdc/using-the-command-line/command-line-syntax/switches-used-in-the-command-line#:~:text=Instead%20use%C2%A0/Include%3AAdditional-,/IncludeColumns,-Alias%3A%C2%A0/ic
https://documentation.red-gate.com/sdc/using-the-command-line/command-line-syntax/switches-used-in-the-command-line#:~:text=with%20unrelated%20names.-,/ExcludeColumns%3A%3Ctable%20or%20view%20name%3E%3A%3Cregular%20expression%3E,-Alias%3A%C2%A0/ec
Thanks - I was able to get it to work via command line. Hope to see in the GUI for less technical users in the future though. / comments
Kurt_M said:
Hi @DrData
The command line actually has more flexibility when it comes to filtering. I would suggest looking into the command line features if your license supports it.
You c...
How to compare tables but exclude certain column(s)?
I have a few columns in a table that SHOULD have different values in Database A and Database B. I only want to see records that have a difference in columns OTHER than a few specified columns. To m...