Error generating HTML report in Command Line

espo4life

I am using SQL Compare 10 with the following command line

SQLCompare /Scripts1:"C:\Database" /db2:"Database" /Server2:"Server" /ScriptFile:"C:\Database\output.sql" /Force /Exclude:User /Report:"c:\Database\DatabaseReport.html" /ReportType:Simple

and it gives me the following with the /Report tag present.

Unexpected error: Object reference not set to an instance of an object.
Object reference not set to an instance of an object.
System.NullReferenceException
   at #i9G.#wamb.#0CIc()
   at #i9G.#wamb.#jcmb()
   at #i9G.#wamb.#9OVb()
   at RedGate.SQLToolsCommandLine.CommandProcessor.#ZjD()
   at RedGate.SQLToolsCommandLine.CommandProcessor.#kcmb()
   at #i9G.#wamb.#kcmb()
   at RedGate.SQLToolsCommandLine.CommandProcessor.#OUb()
   at #i9G.#OsPb.#6sc(String[] #ead)

Any ideas on the problem and how to fix it?

Thanks,
Michael

Brian Donahue

Can you try appending /Include:Identical to the command?

sddesh

Did you find an answer to this issue? Having the same problem. Thanks.

Brian Donahue

Nope. No solution and can't reproduce it in-house.

sddesh

SqlCompare /S1:server1 /db1:database1 /S2:server2 /db2:database2 /Exclude:Schema /Exclude:User /Exclude:Role /Options:Default,IgnoreComments,IgnorePermissions,IgnoreFillFactor,IgnoreWhiteSpace,IgnoreQuotedIdentifiersAndAnsiNullSettings,IgnoreExtendedProperties,IgnoreWithNocheck,IgnoreConstraintNames /report:"C:\test.xml" /reporttype:XML /force /loglevel:verbose

gives the above mentioned "object reference not set to instance of object error". Could you please look at it? Am I doing anything wrong here? This is working when I send the output to a text file using /out: variable (without report generation). But erroring while trying to do a report.

Brian Donahue

Please contact support at red-gate.com by email. We'll probably need to debug the program with you.