Currently on the command line, the /sync option allows you to specify a file to write the sync script to, instead of executing immediately. When no file is specified, the sync is executed immediately. I would like a way to send the results of the sync operation to a log file of type .txt.

I think it would be beneficial to have a couple of different logging levels:

0 - verbose; each object start and stop time, warnings, and errors
1 - warnings; only objects causing warnings or errors to occur
2 - only errors

Warnings should include the object name and the SQL warning
Errors should include the object name and the SQL error

This log would allow me to automate database refreshes, allowing the sync to continue on error, and give me something to look at when it is completed. All of this would be for troubleshooting purposes when something goes wrong or to validate a successful sync

Example call

.\schemacompare.exe /schemacompare /compfile:"C:\MyComparison.scomp" /sync /synclog "c:\synclog.txt" 2

Expecation

A schema compare is performed based on connections and options in C:\MyComparison.scomp with subsequent sync operation based on the compare. The sync operation would be logged to c:\synclog.txt, containing only error information.