Can SQL Compare compare data in tables?

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

Can SQL Compare compare data in tables?

Postby ray023 » Wed Apr 25, 2012 3:55 pm

Given the following argument line:

Code: Select all
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 all
SELECT
   mt1.Visible,
   mt2.Name,
   mt2.Description,
FROM
   MyTable1 mt1
      Inner Join MyTable2 mt2 on mt1.ClassificationID = mt2.ClassificationID
ray023
 
Posts: 2
Joined: Wed Apr 25, 2012 3:35 pm

Postby chriskelly » Fri Apr 27, 2012 4:43 pm

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
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Re:

Postby ray023 » Sat Apr 28, 2012 1:07 pm

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.
ray023
 
Posts: 2
Joined: Wed Apr 25, 2012 3:35 pm

Postby chriskelly » Wed May 02, 2012 7:23 pm

Within SQL Data Compare there is the option to filter data by creating WHERE clauses on table comparison.

http://www.red-gate.com/supportcenter/c ... erformance
(see: Filtering the data)
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests