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." https://nox.tips/
Thanks in advance for your response.
Questions about schema compare for Oracle
-
- Posts: 1
- Joined: Wed 10 Feb 2021 16:15
Questions about schema compare for Oracle
Last edited by coreystol61 on Thu 11 Feb 2021 16:38, edited 1 time in total.
Re: Questions about schema compare for Oracle
Hello,
1) Yes, it is possible to compare 2 schemas in the same database.
2) Yes, you can display the schema name for each object.
3) Technical Writers mistakenly inserted a snippet from the Schema Compare for MySQL documentation.
There must be Oracle versions there. We will fix this bug in the documentation.
1) Yes, it is possible to compare 2 schemas in the same database.
2) Yes, you can display the schema name for each object.
3) Technical Writers mistakenly inserted a snippet from the Schema Compare for MySQL documentation.
There must be Oracle versions there. We will fix this bug in the documentation.
Re: Questions about schema compare for Oracle
It's great! thank youcoreystol61 wrote: ↑Wed 10 Feb 2021 16:26 Hello
fall guys
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
Thanks in advance for your response.