Copmare a db to a backup?

monkeygrind

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?

Tom Harris

Hi,

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

monkeygrind

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.

adson3492

'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.

richardjm

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 - http://documentation.red-gate.com/displ ... g+the+data