Comments
3 comments
-
Hi @Nick22102
I believe you logged a support ticket for this, but I'll pop my response below for everyone.
----------------------------------
I'll paste a couple of links down below of our documentation that you can reference:
Getting started:
https://documentation.red-gate.com/sdc/using-the-command-line/command-line-basics
Examples:
https://documentation.red-gate.com/sdc/using-the-command-line/examples-using-the-command-line/simple-examples-using-the-command-line
https://documentation.red-gate.com/sdc/using-the-command-line/examples-using-the-command-line/example-selecting-single-tables-for-comparison
https://documentation.red-gate.com/sdc/using-the-command-line/examples-using-the-command-line/example-selecting-tables-with-unrelated-names
Different switches:
https://documentation.red-gate.com/sdc/using-the-command-line/command-line-syntax/switches-used-in-the-command-line
To get started with it, you'll want to open a command line (or PowerShell) window in the following directory:
C:\Program Files (x86)\Red Gate\SQL Data Compare 14
Once your CMD or PowerShell window is located in this directory, simply type "SQLDataCoimpare.exe" (or .\SQLDataCompare.exe for PowerShell) and then add your switches in.
Here is an example of me running one on my test environment:
-
Is there an example of comparing two differently named tables? The referenced link for selecting table with unrelated names mentions this but does not explain how to select table1 for comparison against table2.
-
Hi @iragrollman
You'd want to make use of the GUI to create the project with the comparisons you want, then you can reference the project in the command line:
https://documentation.red-gate.com/sdc/setting-up-the-comparison/working-with-projects
https://documentation.red-gate.com/sdc/using-the-command-line/examples-using-the-command-line/simple-examples-using-the-command-line#:~:text
This documentation will show you how to apply the comparisons of different table names in the GUI, and then after that, you can save the project file:
https://documentation.red-gate.com/sdc/setting-up-the-comparison/selecting-tables-and-views
Add comment
Please sign in to leave a comment.
However I did attempt but not even sure If I am doing the right thing.