Stuck at most basic step on attempting to launch Redgate SQL Data projects via CMD

Nick22102

Please advise the most basic steps to kick off a SQL data compare project via CMD as I am not able to find step by step documentation anywhere. 

However I did attempt but not even sure If I am doing the right thing. 

'sqldatacompare14' is not recognized as an internal or external command,

operable program or batch file.

Kurt_M

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:
 

iragrollman

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.

Kurt_M

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