Comments
5 comments
-
Hi,
If you turn on the "Force column order" option (it lives on the Options tab of the connections dialog), Schema Compare for Oracle will rebuild the table and take care of the data in the way you described.
If the "Force column order" option is not enabled, the column will just be added to the table, without a rebuild.
Hope this helps,
Alice. -
Hello,
Thanks for your quick response.
The problem is that when i use the option that you told me about I got a crach of the application. Attached crache log.
Application does not support just-in-time (JIT)
debugging. See the end of this message for details.
************** Exception Text **************
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.ThrowHelper.ThrowKeyNotFoundException()
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at RedGate.Oracle.ObjectModel.ColumnCollection.get_Item(String key)
at H.a(TableDifference )
at H.GetSql()
at RedGate.Oracle.Actions.SyncScript.<get_Lines>d__0.MoveNext()
at RedGate.Oracle.Actions.SyncScript.GetScript()
at RedGate.Oracle.Compare.EngineController.State.Script.ToString()
at Z.a(Object , EventArgs )
at System.EventHandler.Invoke(Object sender, EventArgs e)
at aU.a(EventHandler )
at aU.e()
at aU.b.a()
at aU.NextPage()
at aT.a(Object , EventArgs )
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.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.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINNT/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
RedGate.Oracle.Compare.UI
Assembly Version: 1.0.0.427
Win32 Version: 1.0.0.427
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/RedGate.Oracle.Compare.UI.exe
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINNT/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.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
Ninject.Core
Assembly Version: 1.0.0.82
Win32 Version: 1.0.0.82
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/Ninject.Core.DLL
RedGate.Shared.Controls
Assembly Version: 8.0.0.24
Win32 Version: 8.0.0.24
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/RedGate.Shared.Controls.DLL
DevExpress.Utils.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/DevExpress.Utils.v7.2.DLL
RedGate.Oracle.ObjectModel
Assembly Version: 1.0.0.427
Win32 Version: 1.0.0.427
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/RedGate.Oracle.ObjectModel.DLL
RedGate.Oracle.Compare.EngineController
Assembly Version: 1.0.0.427
Win32 Version: 1.0.0.427
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/RedGate.Oracle.Compare.EngineController.DLL
RedGate.Shared.Utils
Assembly Version: 8.0.0.21
Win32 Version: 8.0.0.21
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/RedGate.Shared.Utils.DLL
RedGate.Licensing.Client
Assembly Version: 2.7.0.6
Win32 Version: 2.7.0.6
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/RedGate.Licensing.Client.DLL
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
DevExpress.XtraBars.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/DevExpress.XtraBars.v7.2.DLL
DevExpress.XtraEditors.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/DevExpress.XtraEditors.v7.2.DLL
DevExpress.Data.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/DevExpress.Data.v7.2.DLL
ActiproSoftware.UIStudio.Dock.Net20
Assembly Version: 2.0.77.0
Win32 Version: 2.0.77.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/ActiproSoftware.UIStudio.Dock.Net20.DLL
ActiproSoftware.Shared.Net20
Assembly Version: 1.0.85.0
Win32 Version: 1.0.85.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/ActiproSoftware.Shared.Net20.DLL
ActiproSoftware.WinUICore.Net20
Assembly Version: 1.0.85.0
Win32 Version: 1.0.85.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/ActiproSoftware.WinUICore.Net20.DLL
System.Design
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll
RedGate.Oracle.Comparison
Assembly Version: 1.0.0.427
Win32 Version: 1.0.0.427
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/RedGate.Oracle.Comparison.DLL
DevExpress.XtraGrid.v7.2
Assembly Version: 7.2.4.0
Win32 Version: 7.2.4.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/DevExpress.XtraGrid.v7.2.DLL
RedGate.Oracle.Actions
Assembly Version: 1.0.0.427
Win32 Version: 1.0.0.427
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/RedGate.Oracle.Actions.DLL
RedGate.Oracle.Utils
Assembly Version: 1.0.0.427
Win32 Version: 1.0.0.427
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/RedGate.Oracle.Utils.DLL
RedGate.Update.Client
Assembly Version: 2.2.0.3
Win32 Version: 2.2.0.3
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/RedGate.Update.Client.DLL
RedGate.Oracle.Serializer
Assembly Version: 1.0.0.427
Win32 Version: 1.0.0.427
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/RedGate.Oracle.Serializer.DLL
Devart.Data.Oracle
Assembly Version: 5.35.57.0
Win32 Version: 5.35.57.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/Devart.Data.Oracle.DLL
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
Devart.Data
Assembly Version: 5.0.17.0
Win32 Version: 5.0.17.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/Devart.Data.DLL
OciCall.dll
Assembly Version: 0.0.0.0
Win32 Version: 5.35.57.0
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/Devart.Data.Oracle.dll
System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINNT/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
RedGate.Oracle.Sql
Assembly Version: 1.0.0.427
Win32 Version: 1.0.0.427
CodeBase: file:///C:/Program%20Files/Red%20Gate/Schema%20Compare%20for%20Oracle%201/RedGate.Oracle.Sql.DLL
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINNT/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
************** JIT Debugging **************
Application does not support Windows Forms just-in-time (JIT)
debugging. Contact the application author for more
information. -
Thanks for posting the stack trace. To help us track down what's going on, can you turn on logging and send us the log file?
This help file explains how to turn on logging:
http://www.red-gate.com/supportcenter/C ... ta_Compare\knowledgebase\logging_and_log_files.htm
If you send the log to me at alice.easey@red-gate.com, that'd be great.
Thanks,
Alice. -
Hi,
The Log was sended to your mail as you ask.
Thanks. -
Can you tell us if you're using the latest build (1.0.0.475)?
If not, can you try downloading it from here - we believe we have fixed this issue in that build.
Please try it out and let us know!
Thanks,
Alice.
Add comment
Please sign in to leave a comment.
I would like to know if your schema compare application supports a rebuild option?
I mean that, if I add a column in a middle of a table I would like to see the application build a script that backs up the existing table, recreates the table, inserts all data from the backup table, and after that delete the backup table.