How can we help you today? How can we help you today?

Can SQL Compare compare data in tables?

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
ray023
0

Comments

3 comments

Sort by
  • chriskelly
    Unfortunately, this isn't possible. You can use the tool SQL Data Compare though to compare the data in your database.
    chriskelly
    0
  • 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.
    ray023
    0
  • 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)
    chriskelly
    0

Add comment

Please sign in to leave a comment.