Is there a feature in Toad for Oracle that will compare all the tables between two schema on different databases and create a sync script that will allow the schema to have the same tables and the same table data? The sync script needs to add or drop the tables and insert or delete data.
There is not a feature in Toad for Oracle that will do all that at one time. In order to get what you want, you will need to do a schema compare in Toad for Oracle and then a data compare in Toad for Data Analysts. The schema compare will give you a sync script to make both schemas have the same objects with the same attributes. The data compare will then give you a script of insert or delete statements that will let you make sure the tables have the same data.
Toad for Data Analysts is a separate application than Toad for Oracle, but is included in the Toad for Oracle purchase. You can install it using the Toad for Oracle installer.
