Questions about schema compare for Oracle
Posted: Thu 16 Aug 2018 08:23
Hello
I am trying schema compare for Oracle, and I am not sure if it is the right tool for my needs.
1) Is it possible to compare 2 schemas in the same database ?
2) In the "Schema Differences Overview", is it possible to display the schema name for each object ?
I have to compare numerous schemas that often contain tables with the same name, so displaying the schema is absolutely needed.
3) In you online documentation "Comparing and Synchronizing Schemas on Different Oracle Server Versions", why are you talking about Oracle version 3.23 or 5 ?? The current versions are 11g, 12c, 18c !
"When comparing schemas on different Oracle servers, some incompatibilities can occur in schema objects. For example, when comparing schemas on Oracle 3.23 and 5.x. Schema on Oracle 5.x can have such objects as views, triggers, stored routines that are not supported on 3.23 server. This topic describes how dbForge Schema Compare for Oracle treats such incompatibilities."
Thanks in advance for your response.
I am trying schema compare for Oracle, and I am not sure if it is the right tool for my needs.
1) Is it possible to compare 2 schemas in the same database ?
2) In the "Schema Differences Overview", is it possible to display the schema name for each object ?
I have to compare numerous schemas that often contain tables with the same name, so displaying the schema is absolutely needed.
3) In you online documentation "Comparing and Synchronizing Schemas on Different Oracle Server Versions", why are you talking about Oracle version 3.23 or 5 ?? The current versions are 11g, 12c, 18c !
"When comparing schemas on different Oracle servers, some incompatibilities can occur in schema objects. For example, when comparing schemas on Oracle 3.23 and 5.x. Schema on Oracle 5.x can have such objects as views, triggers, stored routines that are not supported on 3.23 server. This topic describes how dbForge Schema Compare for Oracle treats such incompatibilities."
Thanks in advance for your response.