Validating the results when using SQL Data Compare through command line
amalik
Posts: 2 New member
in SQL Compare
Hi there!
I'm trying to compare 2 database backups - Graph.bak and Graph2.bak through command line.
After running the following command:
sqldatacompare /Backup1:"C:\Users\amalik\Desktop\Graph.bak" /Backup2:"C:\Users\amalik\Desktop\Graph2.bak" ]
it does give me this result:
Redgate SQL Data Compare Command Line Utility V12.2.1.4077
==============================================================================
Copyright c 1999 - 2017 Redgate Software Ltd
SQL Data Compare: trial, edition standard
Registering databases
Mapping
Comparing databases
Finished
Summary Information
===============================================================================
DB1 = VAL-SQL.Graph
DB2 = VAL-SQL.Graph
Object type Name Records DB1 DB2
Table [dbo].[tblTreeObjects] 2 <> <>
I can verify this manually but the objective is to automate the data comparison so is there a way this command can return whether the data comparison was a success (when backups are identical) or failure (when backups are different)?
Any help would be appreciated.
Thanks!
I'm trying to compare 2 database backups - Graph.bak and Graph2.bak through command line.
After running the following command:
sqldatacompare /Backup1:"C:\Users\amalik\Desktop\Graph.bak" /Backup2:"C:\Users\amalik\Desktop\Graph2.bak" ]
it does give me this result:
Redgate SQL Data Compare Command Line Utility V12.2.1.4077
==============================================================================
Copyright c 1999 - 2017 Redgate Software Ltd
SQL Data Compare: trial, edition standard
Registering databases
Mapping
Comparing databases
Finished
Summary Information
===============================================================================
DB1 = VAL-SQL.Graph
DB2 = VAL-SQL.Graph
Object type Name Records DB1 DB2
Table [dbo].[tblTreeObjects] 2 <> <>
I can verify this manually but the objective is to automate the data comparison so is there a way this command can return whether the data comparison was a success (when backups are identical) or failure (when backups are different)?
Any help would be appreciated.
Thanks!
Tagged:
Comments
I've created a support ticket for you based on this forum post. One of the team will be in touch soon.
In the meantime if any of the community have any suggestions don't be shy!
Thanks for contacting us!
If they are identical it should output exit code 63 - see documentation on exit codes https://documentation.red-gate.com/display/SDC12/Exit+codes+used+in+the+command+line
If you use the GUI, are the two backups actually identical?
Technical Sales Engineer
Redgate Software