excel report customization
Exporting the comparison results as excel file with customization:
We are using Redgate trial version of "SQL Data Compare 14" using command line for the past couple of days for the data comparison work. As of now I understand that while exporting the comparative data in excel, each table result will be available in individual excel and the report summary for the consolidated tables. I want to know whether I can change the format of the excel file which is generated (excel customization). If so, please let me know how to do that process also I have attached the format I need. Please let me know if you need any information from my side.
We use following command to compare:
sqldatacompare /Database1:"TestDB1" /Database2:"TestDB2" /Server1:"TestServer1" /Server2:"TestServer2" /export:"" /force