Object reference not set to an instance of an object
mbenson@frontporch.com
Posts: 12
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.
======
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.
Comments
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
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
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
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569