I was comparing a SQL2000 SQLCompare script to a live database. The script had somehow gotten schemas. I tried to automatically synchronize from the live database to the script to remove the schemas. While I did receive a High Warning that the target did not support schemas (that is the script that already had schemas in it) I tried to synchronize anyway since I was trying to remove the schemas. I then got the following error:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SQLCompare.Engine.Work.ScriptObject(IDatabaseObject objectToScript, Options options)
at _119._1(Difference )
at _116._1(Object , _8 )
at _7._1(Difference )
at _7._3(Object , MouseEventArgs )
at System.Windows.Forms.MouseEventHandler.Invoke(Object sender, MouseEventArgs e)
at DevExpress.XtraGrid.Views.Base.BaseView.RaiseMouseUp(MouseEventArgs e)
at DevExpress.XtraGrid.Views.Grid.Handler.GridHandler.OnMouseUp(MouseEventArgs ev)
at DevExpress.Utils.Controls.BaseHandler.ProcessEvent(EventType etype, Object args)
at DevExpress.XtraGrid.Views.Base.Handler.BaseViewHandler.ProcessEvent(EventType etype, Object args)
at DevExpress.XtraGrid.GridControl.OnMouseUp(MouseEventArgs ev)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
RedGate.SQLCompare.UI
Assembly Version: 6.0.0.1128
Win32 Version: 6.0.0.1128
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.SQLCompare.UI.exe
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
DevExpress.Utils.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.Utils.v6.3.DLL
RedGate.SQL.Shared
Assembly Version: 6.0.0.66
Win32 Version: 6.0.0.66
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.SQL.Shared.DLL
RedGate.SQLCompare.ASTParser
Assembly Version: 6.0.0.780
Win32 Version: 6.0.0.780
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.SQLCompare.ASTParser.DLL
ActiproSoftware.UIStudio.Dock.Net20
Assembly Version: 2.0.77.0
Win32 Version: 2.0.77.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/ActiproSoftware.UIStudio.Dock.Net20.DLL
ActiproSoftware.WinUICore.Net20
Assembly Version: 1.0.85.0
Win32 Version: 1.0.85.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/ActiproSoftware.WinUICore.Net20.DLL
ActiproSoftware.Shared.Net20
Assembly Version: 1.0.85.0
Win32 Version: 1.0.85.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/ActiproSoftware.Shared.Net20.DLL
DevExpress.XtraBars.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.XtraBars.v6.3.DLL
DevExpress.Data.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.Data.v6.3.DLL
DevExpress.XtraEditors.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.XtraEditors.v6.3.DLL
System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
RedGate.SQLCompare.Engine
Assembly Version: 6.0.0.780
Win32 Version: 6.0.0.780
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.SQLCompare.Engine.DLL
DevExpress.XtraPrinting.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.XtraPrinting.v6.3.DLL
DevExpress.XtraGrid.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.XtraGrid.v6.3.DLL
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
RedGate.SQL.Controls
Assembly Version: 6.0.0.66
Win32 Version: 6.0.0.66
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.SQL.Controls.DLL
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
XtraDataTempAssembly
Assembly Version: 0.0.0.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.Data.v6.3.dll
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
RedGate.SQLCompare.Rewriter
Assembly Version: 6.0.0.780
Win32 Version: 6.0.0.780
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.SQLCompare.Rewriter.DLL
RedGate.Update.Client
Assembly Version: 1.2.1.1
Win32 Version: 1.2.1.1
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.Update.Client.DLL
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
RedGate.Controls.FolderDialog
Assembly Version: 1.0.2701.23440
Win32 Version:
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.Controls.FolderDialog.DLL
msvcm80
Assembly Version: 8.0.50727.163
Win32 Version: 8.00.50727.163
CodeBase: file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.163_x-ww_681e29fb/msvcm80.dll
ActiproSoftware.Wizard.Net20
Assembly Version: 3.0.125.0
Win32 Version: 3.0.125.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/ActiproSoftware.Wizard.Net20.DLL
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at RedGate.SQLCompare.Engine.Work.ScriptObject(IDatabaseObject objectToScript, Options options)
at _119._1(Difference )
at _116._1(Object , _8 )
at _7._1(Difference )
at _7._3(Object , MouseEventArgs )
at System.Windows.Forms.MouseEventHandler.Invoke(Object sender, MouseEventArgs e)
at DevExpress.XtraGrid.Views.Base.BaseView.RaiseMouseUp(MouseEventArgs e)
at DevExpress.XtraGrid.Views.Grid.Handler.GridHandler.OnMouseUp(MouseEventArgs ev)
at DevExpress.Utils.Controls.BaseHandler.ProcessEvent(EventType etype, Object args)
at DevExpress.XtraGrid.Views.Base.Handler.BaseViewHandler.ProcessEvent(EventType etype, Object args)
at DevExpress.XtraGrid.GridControl.OnMouseUp(MouseEventArgs ev)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.XtraEditors.Container.EditorContainer.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
RedGate.SQLCompare.UI
Assembly Version: 6.0.0.1128
Win32 Version: 6.0.0.1128
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.SQLCompare.UI.exe
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
DevExpress.Utils.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.Utils.v6.3.DLL
RedGate.SQL.Shared
Assembly Version: 6.0.0.66
Win32 Version: 6.0.0.66
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.SQL.Shared.DLL
RedGate.SQLCompare.ASTParser
Assembly Version: 6.0.0.780
Win32 Version: 6.0.0.780
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.SQLCompare.ASTParser.DLL
ActiproSoftware.UIStudio.Dock.Net20
Assembly Version: 2.0.77.0
Win32 Version: 2.0.77.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/ActiproSoftware.UIStudio.Dock.Net20.DLL
ActiproSoftware.WinUICore.Net20
Assembly Version: 1.0.85.0
Win32 Version: 1.0.85.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/ActiproSoftware.WinUICore.Net20.DLL
ActiproSoftware.Shared.Net20
Assembly Version: 1.0.85.0
Win32 Version: 1.0.85.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/ActiproSoftware.Shared.Net20.DLL
DevExpress.XtraBars.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.XtraBars.v6.3.DLL
DevExpress.Data.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.Data.v6.3.DLL
DevExpress.XtraEditors.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.XtraEditors.v6.3.DLL
System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
RedGate.SQLCompare.Engine
Assembly Version: 6.0.0.780
Win32 Version: 6.0.0.780
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.SQLCompare.Engine.DLL
DevExpress.XtraPrinting.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.XtraPrinting.v6.3.DLL
DevExpress.XtraGrid.v6.3
Assembly Version: 6.3.1.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.XtraGrid.v6.3.DLL
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
RedGate.SQL.Controls
Assembly Version: 6.0.0.66
Win32 Version: 6.0.0.66
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.SQL.Controls.DLL
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
XtraDataTempAssembly
Assembly Version: 0.0.0.0
Win32 Version: 6.3.1.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/DevExpress.Data.v6.3.dll
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
RedGate.SQLCompare.Rewriter
Assembly Version: 6.0.0.780
Win32 Version: 6.0.0.780
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.SQLCompare.Rewriter.DLL
RedGate.Update.Client
Assembly Version: 1.2.1.1
Win32 Version: 1.2.1.1
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.Update.Client.DLL
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
RedGate.Controls.FolderDialog
Assembly Version: 1.0.2701.23440
Win32 Version:
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/RedGate.Controls.FolderDialog.DLL
msvcm80
Assembly Version: 8.0.50727.163
Win32 Version: 8.00.50727.163
CodeBase: file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.163_x-ww_681e29fb/msvcm80.dll
ActiproSoftware.Wizard.Net20
Assembly Version: 3.0.125.0
Win32 Version: 3.0.125.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/SQL%20Compare%206/ActiproSoftware.Wizard.Net20.DLL
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.