Copmare a db to a backup?

Compares and synchronizes Oracle data

Copmare a db to a backup?

Postby monkeygrind » Sat Jan 21, 2012 2:15 am

Sorry if this is strange but I'm new to Oracle. In the MS Sql Compare, I can compare a database backup to a live database and propagate deltas from the former to the latter.

I can't seem to see how to do this with the Oracle compare tools - is there something I'm missing or is this feature not supported in Oracle?
Posts: 28
Joined: Wed Jun 21, 2006 9:57 pm
Location: Seattle-ish

Postby Tom Harris » Thu Jan 26, 2012 6:22 pm


many thanks for your question. You are correct, this functionality is only currently available in the MS SQL Server versions of our tools. I have made a note of your request though, and we'll get back in touch if/when development starts on the Oracle front.

Kind regards, Tom

Tom Harris, Red Gate
Tom Harris
Posts: 308
Joined: Wed Oct 06, 2004 2:45 pm

Postby monkeygrind » Thu Jan 26, 2012 6:48 pm

Thanks Tom! It would really help when in situations where a user doesn't have a local instance of Oracle on their workstation and trying to restore to a pre-production instance reuqires involvemen of a dba.
Posts: 28
Joined: Wed Jun 21, 2006 9:57 pm
Location: Seattle-ish

Re: Copmare a db to a backup?

Postby adson3492 » Wed Dec 10, 2014 4:54 am

've the same problem with CLOBS fields.. When I open it with diff viewer it cuts its contents (i don't no why). It would be cool if had an option to just show the field with full value, with no comparison.
We provide fast success in 300-207 - latest dumps dumps exam by using our high quality OG0-091 - pass4sure - prep resources. We offer up-to-dated tabor and join dumps
Posts: 1
Joined: Wed Dec 10, 2014 4:39 am

Re: Copmare a db to a backup?

Postby richardjm » Tue Dec 23, 2014 1:12 pm

Any chance you could send us a screenshot of what you're seeing cut-off in Data Compare for Oracle.

I don't think it intentionally truncates values in the viewer - ... g+the+data
Richard Mitchell
Project Manager
Red Gate Software Ltd
Posts: 523
Joined: Fri May 20, 2005 8:44 am
Location: Red Gate Software Ltd

Return to Data Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests