Comparison, synchronization of 7.3 and 11gR2 db, possible ?

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
pgineste
Posts: 1
Joined: Thu 16 Jun 2011 12:05

Comparison, synchronization of 7.3 and 11gR2 db, possible ?

Post by pgineste » Thu 16 Jun 2011 12:23

Hello devart team,

We have an oracle source database version 7.3 and a target database 11gR2
Can you answer me to the following questions :
- using dbforge compare schema professional, is it possible to compare
such 7.3 source and 11gR2 target database without using any oracle
client software ?

- using dbforge compare schema professional, is it possible to compare
and synchronize wrapped PL/SQL objects of source oracle 7.3 objects ?

- i've heart that there are limitations on grant comparison ?
can you give a link describing such limitations ?

- using oradeveloper, is it possible to do sql reverse of
a database schema, an sql role reverse along with all associated
grants?

Thank you very much in advance,
Best regards,
P. Gineste

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Post by .jp » Thu 16 Jun 2011 13:26

Thanks for the questions.

For the time being dbForge Schema Compare for Oracle does not support Oracle 7.3 and 8, 8i (neither via client, nor in the Direct mode). The oldest supported version of Oracle is 9i.
We plan to add support for Oracle 7.3, 8, and 8i in the nearest future.

dbForge Schema Compare for Oracle allows to compare and synchronize wrapped source objects only for Oracle versions 9i or higher.

dbForge Schema Compare for Oracle supports only privileges that are granted directly to objects.

OraDeveloper allows working with any kind of privileges and get DDLs of schemas and supports Oracle servers starting from 7.3 (via client and in the Direct mode).
You can get acquainted with its possibilities by downloading its fully-functional trial version with limited usage period:
http://www.devart.com/dbforge/oracle/st ... nload.html

Post Reply