Command-line compare using project file

• 
  Hi Dan,
  
  You can use your project file from the command line by using the /Project switch and doing something similar to the following...
  

  sqldatacompare.exe /Project:"C:SQLCompareProjectsWidgets.scp"
  

  Rob C January 23, 2015 12:08

  - 0 +
• 
  I guess it's time for new eyeglasses. I looked through the documentation and somehow missed that switch.
  
  Thanks,
  
  Dan

  Dan Guzman January 23, 2015 14:17

  - 0 +
• 
  I know I need glasses because I cannot figure out where sql script file goes.
  
  I know /Export will create a csv file, but in the above example where is sql script file that will do the synchronizing?
  
  Thanks

  mtm_king April 02, 2015 17:34

  - 0 +
• 

  sqldatacompare.exe /?
  

  will describe the command line syntax. You can add /verbose for more detail.
  
  To generate a SQL synchronization script, use

  sqldatacompare.exe /scriptfile:<destination_file_path>
  

  
  Or to actually run the synchronization, use

  sqldatacompare.exe /synchronize
  

  
  Obviously you'll need to combine these arguments with the project file or source and target database arguments.

  Mike U April 07, 2015 10:50

  - 0 +

Add comment

Please sign in to leave a comment.