Red Gate forums :: View topic - Different results between application and command line
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Different results between application and command line

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
PaulGoldstraw



Joined: 17 Jun 2010
Posts: 10

PostPosted: Mon Feb 03, 2014 11:33 am    Post subject: Different results between application and command line Reply with quote

Hi,

I am currently trialling SQL Compare using the command line, and seem to be getting some slightly odd results. I have tried to include an image of what I get in the application itself, which shows there to be no difference detected in any of the rows shown.



When I make the same comparison on the command line, I get the following report output:


Code:
<line type="same">
      <left>[rowguid] [uniqueidentifier] NOT NULL ROWGUIDCOL CONSTRAINT [DF_Address_rowguid] DEFAULT (newid()),</left>
      <right>[rowguid] [uniqueidentifier] NOT NULL ROWGUIDCOL CONSTRAINT [DF_Address_rowguid] DEFAULT (newid()),</right>
</line>
<line type="same">
      <left>[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Address_ModifiedDate] DEFAULT (getdate())</left>
      <right>[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Address_ModifiedDate] DEFAULT (getdate())</right>
</line>
<line type="same">
      <left>)</left>
      <right>)</right>
</line>
<line type="same">
      <left>GO</left>
      <right>GO</right>
</line>
<line type="different">
      <left>-- Constraints and Indexes</left>
      <right>-- Constraints and Indexes</right>
</line>
<line type="same">
      <left />
      <right />
</line>
<line type="same">
      <left>ALTER TABLE [Person].[Address] ADD CONSTRAINT [PK_Address_AddressID] PRIMARY KEY CLUSTERED  ([AddressID])</left>
      <right>ALTER TABLE [Person].[Address] ADD CONSTRAINT [PK_Address_AddressID] PRIMARY KEY CLUSTERED  ([AddressID])</right>
</line>
<line type="same">
      <left>GO</left>
      <right>GO</right>
</line>


Note the difference detected for the commented line, but the data clearly supports the application's result set; there is no difference. Is this a bug in the command line interface? Is there a setting I need to use to avoid this? I've just got the default settings for both the application and the command line equivalent, with the command line outputting a report to an XML file, but perhaps something is on or off by default that I need to change?
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 663
Location: Cambridge

PostPosted: Wed Feb 05, 2014 12:51 pm    Post subject: Reply with quote

Thanks for your post.

I have logged a support ticket for you and will email you shortly.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group