Schedule a Data compare using a batch file

• 
  Hi Richard,
  
  What syntax are you using for your batch file?
  
  The syntax with SQL Data Compare 8 has now changed per the below link:
  
  http://www.red-gate.com/supportcenter/C ... 700052.htm
  
  If you want to post your batch file though I can have a look at it for you.
  
  Pete

  peter.peart October 08, 2009 11:52

  - 0 +
• 
  Hi Pete,
  
  The command line is:
  
  "C:\Program Files\Red Gate\SQL Data Compare 8\RedGate.SQLDataCompare.UI.exe" /compare "S36Admin_S46AdminReporting_Blobs_V8.sdc"
  Pause
  
  And I'm running from within a Scheduled Task. Thanks for your help.
  
  Cheers,
  
  Richard

  RichP October 14, 2009 09:36

  - 0 +
• 
  Hi again Pete,
  
  After further investigation I've come to the conclusion that in V8 the following 3 commands do the same thing, namely open a blank project:
  
  "C:\Program Files\Red Gate\SQL Data Compare 8\RedGate.SQLDataCompare.UI.exe" /compare "D:\SQLDataCompare\S47CGD_PPIAdmin_S46CGD_PPIAdminReporting.sdc"
  "C:\Program Files\Red Gate\SQL Data Compare 8\RedGate.SQLDataCompare.UI.exe" /compare "S47CGD_PPIAdmin_S46CGD_PPIAdminReporting.sdc"
  "C:\Program Files\Red Gate\SQL Data Compare 8\RedGate.SQLDataCompare.UI.exe" /Project:"D:\SQLDataCompare\S47CGD_PPIAdmin_S46CGD_PPIAdminReporting.sdc"
  
  The following command does nothing:
  
  sqldatacompare /Project:"D:\SQLDataCompare\S47CGD_PPIAdmin_S46CGD_PPIAdminReporting.sdc"
  
  I really want to run these jobs using files I've created in the GUI, i.e at a high level. Any advice?
  
  I've gone back to using V6, as it does what I want......
  
  Cheers,
  
  Richard

  RichP October 15, 2009 05:59

  - 0 +
• 
  Hi Richard,
  
  Per the below taken from the SQL Data Compare help file, the syntax for referencing a project should be:
  
  sqldatacompare /Project:"C:\SQLDataCompare\Projects\Widgets.sdc"
  
  To confirm, I have tested this on my machine creating a project in SQL Data Compare 8 and running the below through the command line:
  
  sqldatacompare /Project:"C:\Documents and Settings\Peter.Peart\My Documents\SQL Data Compare\SharedProjects\WidgetDev v WidgetLive.sdc"
  
  Once executed, this returns the following from CMD:
  
  C:\Program Files\Red Gate\SQL Data Compare 8> sqldatacompare /project:"C:\Documents and Settings\Peter.Peart\My Documents\SQL Data Compare\SharedProjects\WidgetDev v WidgetLive.sdc"
  
  Red Gate SQL Data Compare Command Line Utility V8.0.2.5
  ==============================================================================
  Copyright © Red Gate Software Ltd 1999-2009
  
  Serial Number: xxx-xxx-xxxxxx-xxxx
  
  Registering databases
  Mapping
  Comparing databases
  Finished
  
  Summary Information
  ===============================================================================
  DB1 = SLS-PETE\SQL2005.WidgetDev
  DB2 = SLS-PETE\SQL2005.WidgetLive
  
  Object type Name Records DB1 DB2

  ---

  Table [dbo].[Contacts] 7 <> <>
  Table [dbo].[WidgetDescriptions] 2 <> <>
  Table [dbo].[WidgetDescriptions] 1 <<
  Table [dbo].[WidgetPrices] 1 <> <>
  Table [dbo].[WidgetPrices] 3 >>
  Table [dbo].[WidgetPurchases] 854 <> <>
  Table [dbo].[WidgetPurchases] 10156 <<
  Table [dbo].[Widgets] 1 >>
  Table [dbo].[Widgets] 1 <<
  
  If I add the /synchronize switch after the original command then this also synchronizes the databases.
  
  Can you confirm if these project files have been opened through the GUI with SQL Data Compare 8 yet?
  
  Pete

  peter.peart October 15, 2009 15:08

  - 0 +
• 
  Hi Pete,
  
  Yes they've been opened and saved in V8.
  
  Richard

  RichP October 16, 2009 05:01

  - 0 +
• 
  Hi Rich,
  
  What happens when you reference the project file through CMD? Does that run and is it just the batch file that is failing or is it both?
  
  Pete

  peter.peart October 16, 2009 05:57

  - 0 +

Add comment

Please sign in to leave a comment.