Hi,
Can any one help me. I am trying to compare the data of two revisions of my source controlled database. The background to this; is that I am trying to compare static data in a particular way. I am using xml to specify the command line arguments to define this comparison. I am calling sql data compare withe the following code:
SQLDataCompare.exe /argfile:C:\temp\DataCompareArgs.xml /verbose
The xml syntax is below:
<?xml version="1.0"?>
<commandline>
<scriptsfolderxml>C:\temp\ScriptFolderLocation.xml</scriptsfolderxml>
<sourcecontrol1/>
<revision1>HEAD</revision1>
<sourcecontrol2/>
<revision2>49</revision2>
<!-- Include only the tables that you are intersetd in and define the comparison key you wish to compare on. Exclude the primary key for comparison -->
<Include>Table:Foo</Include>
<ComparisonKeys>Foo:ix_foo_some_id</ComparisonKeys>
<ExcludeColumns>Foo:PrimaryKey</ExcludeColumns>
<ScriptFile>C:\temp\DataDiff.sql</ScriptFile>
</commandline>
On executing the the above code I get the following output:
Registering databases
Mapping
Error: Object reference not set to an instance of an object.
As you can see i am getting a object reference exception.
If i edit the args xml and replace the nodes
<sourcecontrol2/><revision2>49</revision2> with
<database2>Target</database2> the command will work. So the problem must persist in comparing two revisions in source control.
Any help would be greatly recieved.
Thanks
I decided to try and accomplish my original goal by using the UI and it does exactly what I want. But when calling it from the command line I get the same error as before Object reference not set to an instance of an object.
Can any one help me. I am trying to compare the data of two revisions of my source controlled database. The background to this; is that I am trying to compare static data in a particular way. I am using xml to specify the command line arguments to define this comparison. I am calling sql data compare withe the following code:
The xml syntax is below:
On executing the the above code I get the following output:
Registering databases
Mapping
Error: Object reference not set to an instance of an object.
As you can see i am getting a object reference exception.
If i edit the args xml and replace the nodes <sourcecontrol2/><revision2>49</revision2> with <database2>Target</database2> the command will work. So the problem must persist in comparing two revisions in source control.
Any help would be greatly recieved.
Thanks