Can we dump the database output in excel sheet from this tool?
rashmi
Posts: 1 New member
in SQL Compare
Hi,
I have compared two databases and got the output but i want this output in excel sheet. Is it possible with this tool or i have to generate it manually?
I have compared two databases and got the output but i want this output in excel sheet. Is it possible with this tool or i have to generate it manually?
Tagged:
Answers
You can output the report as an XML for Excel, which when you open it populates the cells in Excel. If you are using the UI, you will need to use the Tools > Generate comparison results report.. option, but you can also create a command line script to run the comparison and generate the report.
Generate a report:
https://documentation.red-gate.com/sc13/reviewing-the-comparison-results/generating-a-report
Command line switches:
https://documentation.red-gate.com/sc13/using-the-command-line/switches-used-in-the-command-line
Kind regards,
Alex
Have you visited our Help Center?