Visual Studio 2017 data comparison, command line

Question

I use this feature in Visual Studio to easily sync data from one database to another

https://msdn.microsoft.com/en-us/library/aa833428(v=vs.100).aspx

You can save the data comparison settings to a .dcmp file. Each time I open the .dcmp file, it performs a comparison, and I can click the refresh button to write the data to DEV.

But how can I run this automatically? Is there a command line to run the .dcmp file?

Answer 1

For latest versions of VS
You have the Sql.NewDataComparison team. Take a look here .

For vs2010 You have the Data.NewDataComparison command, run it with devenv.
Create a batch file if you need to automate it.
More about the NewDataComparison team here and here .