Automate compare of static data from Source Control version B to Source Control version a
JohnnyS
Posts: 2 New member
We have the SQL Toolbelt Essentials (NO SQL Automation) and we are committing static data changes to SQL Source Control (not schema changes). Our goal is to automate comparisons of the static data in Source Control versions and to separate out the process of moving new rows ('Source Only' in SQL Data Compare) from the process of moving updates ('Different' in SQL Data Compare).
I have been unable to find any documentation or help on comparing Source Control versions to other Source Control versions via command line. Has anyone done this or have some documentation/examples to point me to?
Thanks in advance!
Johnny
I have been unable to find any documentation or help on comparing Source Control versions to other Source Control versions via command line. Has anyone done this or have some documentation/examples to point me to?
Thanks in advance!
Johnny
Tagged:
Answers
You use the same syntax as you do in SQL Compare described on this page:
https://documentation.red-gate.com/sc/using-the-command-line/switches-used-in-the-command-line#Switchesusedinthecommandline-/Sourcecontrol1
Which will look something like this:
SQLDataCompareThe creation of sfx.txt (ScriptsFolderXML - found from SQL Source Control) is described here:
https://documentation.red-gate.com/sc/using-the-command-line/switches-used-in-the-command-line#Switchesusedinthecommandline-/ScriptsFolderXML:%3Cfilepath%3E
I'll see about getting the SQL Data Compare documentation updated to include the source control source and target information!
Kind regards,
Alex
Have you visited our Help Center?
The documentation for SQL Data Compare has now been updated with this information as well.
Kind regards,
Alex
Have you visited our Help Center?