How can we help you today? How can we help you today?

Error generating HTML report in Command Line

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
espo4life
0

Comments

5 comments

Sort by
  • Brian Donahue
    Can you try appending /Include:Identical to the command?
    Brian Donahue
    0
  • sddesh
    Did you find an answer to this issue? Having the same problem. Thanks.
    sddesh
    0
  • Brian Donahue
    Nope. No solution and can't reproduce it in-house.
    Brian Donahue
    0
  • 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.
    sddesh
    0
  • Brian Donahue
    Please contact support at red-gate.com by email. We'll probably need to debug the program with you.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.