sqlcompare Object reference not set to an instance of an obj

mchickey

Hi,
Recently bought version 4.1.0.59 and it works well on most databases.
However on one particular db, I always get the following message no
matter what options in include/exclude.

"Object reference not set to an instance of an object".

With all options, it seems to take the same amount of time, then fail at the end.
The temp folder contains sp's and views but never tables so I cannot find
out which is causing the problem.

Any help gratefully received.

The command and the message are as follows:

sqlcompare /server1:jupiter /database1:information_systems_associates_ltd_mscrm
/server2:triton /database2:adventure_works_cycle_demo_mscrm
/exclude:StoredProcedure /exclude:Table /exclude:View /exclude:Function
/exclude:Role /exclude:Schema /exclude:User

.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
RedGate.SQLCompare.CommandLine.CommandProcessor.GetComparisonExecutionBlock()

at RedGate.SQLCompare.CommandLine.CommandProcessor._4()
at RedGate.SQLCompare.CommandLine.CommandProcessor.Run()
at RedGate.SQLCompare.CommandLine.Startup._1(String[] )

Brian Donahue

Hello,

Usually this happens because there is some incorrect information in one or more of the system tables. If you register this database in the UI version of SQL Compare, what is the last message that you see in the status bar? That may give a clue as to which bits of the database's system tables aren't returining the correct information.

mchickey

The last thing I can spot is "reading foreign keys". It's pretty fast, so I might be missing something.

I'll look into this and see what comes up.

Thanks.