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

Object reference not set to an instance of an object

I get the error "Object reference not set to an instance of an object." in the Synchronization Wizard when I click Next on the first step when there are certain stored procedures checked.

======

color=green]check[/color Mapping database
X Calculating dependencies
calculating work to do
[grey dot] Complete

[i symbol] Object reference not set to an instance of an object.

======

It started with just one stored procedure in particular, but now there are a few of them that lead to this error. And it won't let me get a script when they are checked.

I am using SQL Compare 8.1.0.360 with SQL 2005 as the source and SQL 2008 as the destination and vice-versa (also tried it with both sides being SQL 2005 on the same server instance).
I tried it on both Windows XP and Windows 7 and get the same error.

Please help me.
mbenson
0

Comments

5 comments

  • peter.peart
    Hi Marty,

    Please could you try this with the latest cumulative patch of SQL Data Compare available from below and let me know how you get on?

    http://www.red-gate.com/MessageBoard/vi ... php?t=9880

    Many thanks!

    Pete
    peter.peart
    0
  • mbenson
    I don't understand why I would install a SQL Data Compare patch when I am trying to get SQL Compare (no Data) to work. Can you please explain why I would do this? Thanks
    mbenson
    0
  • peter.peart
    Hi Marty,

    Apologies, you should use the patch described in the below link:

    http://www.red-gate.com/messageboard/vi ... php?t=9860

    If this does not work, please can you send an e-mail to support(at)redgate.com and we will troubleshoot this further.

    Many thanks!

    Pete
    peter.peart
    0
  • mbenson
    Looks like that fixed it. Thanks!
    mbenson
    0
  • mbenson
    Ok, it looks like it may have fixed it for one case, but there are still procedures where I get that error when initiating a synch.
    mbenson
    0

Add comment

Please sign in to leave a comment.