Visual Studio 2017 Data Comparison, command line

Question

I'm using this function 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 Compare settings into a .dcmp file. Everytime I open the .dcmp file, it runs a comparison and I can press the update button to write data to DEV.

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

Answer 1

Visual Studio 2017

There is the Tools.NewDataComparison command.

Visual Studio 2012-2015 (?)

You have the Sql.NewDataComparison command. Look here.

Visual Studio 2010

You have the Data.NewDataComparison command, run it from devenv.
Create a batch file if you need to automate this.
More on NewDataComparison command here and here.