Can SQL Compare compare data in tables?

ray023

Given the following argument line:

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:

SELECT 
	mt1.Visible,
	mt2.Name,
	mt2.Description,
FROM
	MyTable1 mt1 
		Inner Join MyTable2 mt2 on mt1.ClassificationID = mt2.ClassificationID

chriskelly

Unfortunately, this isn't possible. You can use the tool SQL Data Compare though to compare the data in your database.

ray023

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.

chriskelly

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)