Rebuild tables

Early Access Program for Schema Compare for Oracle

Moderators: David Atkinson, eddie davis, richardjm, alice.easey, Tom Harris

Rebuild tables

Postby maxlib » Tue Jan 12, 2010 9:29 am

Hello,

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.
maxlib
 
Posts: 8
Joined: Tue Dec 29, 2009 12:48 pm

Postby alice.easey » Tue Jan 12, 2010 11:49 am

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.
alice.easey
 
Posts: 93
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate

Crash

Postby maxlib » Tue Jan 12, 2010 11:57 am

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.
maxlib
 
Posts: 8
Joined: Tue Dec 29, 2009 12:48 pm

Postby alice.easey » Tue Jan 12, 2010 2:30 pm

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.
alice.easey
 
Posts: 93
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate

Crache

Postby maxlib » Tue Jan 12, 2010 2:52 pm

Hi,

The Log was sended to your mail as you ask.

Thanks.
maxlib
 
Posts: 8
Joined: Tue Dec 29, 2009 12:48 pm

Postby alice.easey » Tue Jan 12, 2010 3:50 pm

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.
alice.easey
 
Posts: 93
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate


Return to Schema Compare for Oracle Beta

Who is online

Users browsing this forum: No registered users and 0 guests

cron