Red Gate forums :: View topic - Multiple Comparisons using Folder as Target
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Schema Compare for Oracle
Schema Compare for Oracle forum

Multiple Comparisons using Folder as Target

Search in Schema Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
eandrews



Joined: 06 Jan 2014
Posts: 4
Location: United States

PostPosted: Mon Jan 06, 2014 7:09 pm    Post subject: Multiple Comparisons using Folder as Target Reply with quote

Is it possible to keep a Script Folder up to date using Schema Compare 3 for Oracle?

I used Schema Compare to create the Script Folders. I then went an created a new table in the Oracle database, started Schema Compare using Oracle as the Source and the folders originally created as the Target. All of the objects are identified correctly but when I go to the Deployment Wizard I receive the following error (from the log file itself). I will get what appears to be an endless amount of errors in the Dialog box and I can't close the application (have to kill using Task Manager).

11:56:44.760|Trace |Actions |30 |:Finding sync issues in type RedGate.Oracle.SchemaCompare.Comparison.TableDifference
11:56:44.904|Error |Engine Service |1 |:Exception in progress dialog
System.ArgumentException: An item with the same key has already been added.
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at #7DD.#RED.FindSyncIssues(IEnumerable`1 #tIc, #TED #TsPb)
at #7DD.#mED.#ARD(IEnumerable`1 #tIc, #TED #TsPb)
at RedGate.Oracle.SchemaCompare.Actions.SyncActions.FindSyncIssues()
at RedGate.Oracle.Compare.EngineController.Schema.ProgressTasks.FindSyncIssuesProgressTask.<>c__DisplayClass2.<.ctor>b__0()
at RedGate.Shared.Controls.ProgressDialogEx.<>c__DisplayClass8.<DoTasks>b__3(Object q)
Back to top
View user's profile Send private message
eandrews



Joined: 06 Jan 2014
Posts: 4
Location: United States

PostPosted: Wed Jan 08, 2014 2:55 pm    Post subject: Multiple Comparisons using Folder as Target Reply with quote

Redgate support has looked into my particular issue and it appears that it has something to do with our "RELY DISABLE" statements we are using to identify foreign keys but disable them. This is being done to provide information to the optimizer without having the engine enforce the rule.

It appears to work correctly with multiple comparisons on tables not utilizing this particular feature.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group