Automate compare of static data from Source Control version B to Source Control version a

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

Johnny Stevens April 16, 2020 19:17

Comments

2 comments

Hi JohnnyS,

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:
SQLDataCompare
```
.exe /Sourcecontrol1 /revision1:4 /Sourcecontrol2 /revision2:3 /sfx:"E:\ZD Ticket Files\Z159781\sfx.txt"
```
The 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
Alex B April 20, 2020 16:42

0
Hi @JohnnyS,

The documentation for SQL Data Compare has now been updated with this information as well.

Kind regards,
Alex

Alex B April 30, 2020 07:18

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Automate compare of static data from Source Control version B to Source Control version a

Comments

Add comment