Red Gate forums :: View topic - Issue when populating synonyms
Return to www.red-gate.com RSS Feed Available

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

Issue when populating synonyms

Search in Schema Compare for Oracle Beta forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
mpalaric



Joined: 02 Feb 2010
Posts: 1

PostPosted: Tue Feb 02, 2010 3:04 pm    Post subject: Issue when populating synonyms Reply with quote

I've tried to compare the same schema in two Oracle 10g databases with tns connection (one is the dev database and the other is the integration db). When populating synonyms on database two, schemacompare aborts with the following exception in log:

12:13:24.364|Error |Object Model |3 |ProgressTask:Exception thrown while populating database baset1
System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
RedGate.Oracle.ObjectModel.DatabaseFactory.C()
RedGate.Oracle.ObjectModel.DatabaseFactory.Populate()
RedGate.Oracle.ObjectModel.OracleDatabase.Register(IScriptExecutor dbReader, IEnumerable`1 schemas)
12:13:25.161|Error |Engine Service |1 |:Exception in progress dialog
System.InvalidCastException: Unable to cast object of type 'System.DBNull' to type 'System.String'.
RedGate.Oracle.ObjectModel.DatabaseFactory.C()
RedGate.Oracle.ObjectModel.DatabaseFactory.Populate()
RedGate.Oracle.ObjectModel.OracleDatabase.Register(IScriptExecutor dbReader, IEnumerable`1 schemas)
RedGate.Oracle.ObjectModel.OracleDatabase.Register(String oracleHome, String connectionString, IEnumerable`1 schemas)
f.<>c__DisplayClass2.<GetProgressMethod>b__0()
RedGate.Shared.Controls.ProgressDialogEx.e()

I'm using version 1.0.0.475.
Back to top
View user's profile Send private message
alice.easey



Joined: 27 Feb 2008
Posts: 93
Location: Red Gate

PostPosted: Wed Feb 03, 2010 12:36 pm    Post subject: Reply with quote

Hi,

Thanks for your post and for trying out the early access build.

Schema Compare for Oracle doesn't currently support synonyms, but we are planning to for v1.

We'd really appreciate it if you could send us some query snapshots of your database schema. You should find the RedGate.Oracle.CreateQuerySnapshot.exe program in the install directory of Schema Compare for Oracle. This tool stores the results of the queries we run against the database when registering.

Its possible that the file generated might be quite big, so it might be necessary to zip it up before emailing it over. If its still too big to send, let me know and Ill provide details of an FTP site.

Thanks,

Alice.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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