What are the challenges you face when working across database platforms? Take the survey
Options

Can SQL Compare compare data in tables?

ray023ray023 Posts: 3
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

Comments

Sign In or Register to comment.