Add an ignore option for Schema Compare to skip when errors occur, e.g. Error: Object reference not set to an instance of an object
Error: Object reference not set to an instance of an object is displayed and Schema Compare stops. It would be better if it were possible to continue beyond this error and just have a logfile of errors with details of the objects that failed.
Simon Williams
shared this idea
The problem with supporting this is that once the first error happens (e.g. failing to populate a table) the errors snowball (now the view that uses that table fails, the index for that table also fails) to such an extent that it’s very difficult to find the first failure.
Submitting error reports to us is the best way to get fixes.
-
AdminRichard Mitchell
(Admin, Redgate)
commented
If you submit an error report when this happens we can try to get to the bottom of it (as of course it shouldn't happen). I know Data Compare for Oracle can do some degree of skipping "strange" values but it's not something we've got in Schema Compare yet.