9

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?

Jack
  • 5,680
  • 10
  • 49
  • 74

1 Answers1

5

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.

Stu
  • 15,675
  • 4
  • 43
  • 74
igorc
  • 2,024
  • 2
  • 17
  • 29