SqlDataCompare

Simple program to compare sql tables.

• Add the connection strings on the app.config

  SqlDataCompare  [db1] [db2] [table] (dstFile)

Where

• db1: The name of the source connection string
• db2: The name of the destination connection string
• table: The name of the table in format schema.tableName
• dstFile(optional): The destination file. Will be written on the executable directory unless is an absolute path

Compare table '[dbo].[Items]' from 'SrcData' with 'DstData'

Missing field 'IsOnOff' on destination.

Different
~ (GroupId=1,Name=Other,PackageId=4,SortOrder=50,Type=Core) FROM
  (GroupId=1,Name=Other,PackageId=4,SortOrder=50,Type=Ancillary)

Missing on source
- (-) FROM (GroupId=1,Name=Graphics,PackageId=2,SortOrder=50,Type=Core)

Missing on destionation
+ (GroupId=1,Name=Extra,PackageId=8,SortOrder=10,Type=Smart) FROM (-)