Issue when populating synonyms

Early Access Program for Schema Compare for Oracle

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

Issue when populating synonyms

Postby mpalaric » Tue Feb 02, 2010 3:04 pm

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.
mpalaric
 
Posts: 1
Joined: Tue Feb 02, 2010 11:49 am

Postby alice.easey » Wed Feb 03, 2010 12:36 pm

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.

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

Thanks,

Alice.
alice.easey
 
Posts: 94
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