This feature is available only in the Xpert or DBA editions. Later on in this example, I also show you the option to synchronize script. Luckily, the Compare Schemas tool is available in the Base Edition, which means its available in every edition. Toad for Oracle offers many different editions, the higher the edition, the more features and capabilities. To solve this situation, we have a perfect solution available from Toad for Oracle, which is the Compare Schemas tool. Of course, today, when working on large projects, complexity has greatly increased as there can be so many different and interrelated object types that it is no longer possible to simply use simple, self-made scripts. Several years ago, when I started in Oracle technologies, my first contact was in Database Administration and in those days I remember that as I was getting started in that new world, I typically would just manage few objects from the Oracle database-such as tables, indexes, synonyms, views-and could generate simple scripts to be able to determine the differences in both environments without much difficulty. Make sure to read my second blog in this series, How to compare multiple database schemas in Oracle using Toad. I will guide you step by step on how we can compare two Oracle database schemas using Toad® by Quest® for Oracle. If you find yourself in any of the above situations, this article is for you.
0 Comments
Leave a Reply. |