Red Gate forums :: View topic - Can SQL Compare compare data in tables?
Return to www.red-gate.com RSS Feed Available

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

Can SQL Compare compare data in tables?

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



Joined: 25 Apr 2012
Posts: 2
PostPosted: Wed Apr 25, 2012 3:55 pm    Post subject: Can SQL Compare compare data in tables? Reply with quote
Given the following argument line:

Code:
string arguments = String.Format("/Database1:{0} /Database2:{1} /Exclude:Identical /Options:Default,IgnoreWhiteSpace,IgnoreComments,CaseSensitiveObjectDefinition,ForceColumnOrder,IgnorePermissions /Report:\"{2}\" /ReportType:Interactive /Force",
                                           ConfigurationManager.AppSettings["OriginalDatabase"],
                                           ConfigurationManager.AppSettings["UpdatedDatabase"],
                                          compareResultsFilePath);




Is there a way to append and compare results of a sql statement like this:

Code:
SELECT
   mt1.Visible,
   mt2.Name,
   mt2.Description,
FROM
   MyTable1 mt1
      Inner Join MyTable2 mt2 on mt1.ClassificationID = mt2.ClassificationID
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 253
Location: Cambridge, UK
PostPosted: Fri Apr 27, 2012 4:43 pm    Post subject: Reply with quote
Unfortunately, this isn't possible. You can use the tool SQL Data Compare though to compare the data in your database.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
ray023



Joined: 25 Apr 2012
Posts: 2
PostPosted: Sat Apr 28, 2012 1:07 pm    Post subject: Re: Reply with quote
chrisk5 wrote:
Unfortunately, this isn't possible.


Not possible at all?

Just trying to clarify.

We do have SQL Data Compare 8; but, from what I can tell, it looks like you can only compare tables.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 253
Location: Cambridge, UK
PostPosted: Wed May 02, 2012 7:23 pm    Post subject: Reply with quote
Within SQL Data Compare there is the option to filter data by creating WHERE clauses on table comparison.

http://www.red-gate.com/supportcenter/content/SQL_Data_Compare/articles/getting_better_performance
(see: Filtering the data)
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
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