This sync script is a time as well as a life saver, as it cuts down the time required to modify your production schema as well as reduces the number of errors and mistakes that you might make if you had to do this manually. The sync script tab has a script that you can run on the target schema to make it look like the source schema.
The more interesting tab is the Sync Script tab. You can also output the differences to an excel sheet or a HTML report. 
This will allow you to quickly jog your memory about what all changed between your development and production schemas.
The result tab shows you in a tree what is different as well as similar between the 2 schemas. This will result in 2 new tabs being added to Toad Compare space. Once you have set up how Toad should compare your schemas hit the "Begin Schema Compare" button. 
The second tab "Object Type Specific Options" is equally important as it allows you to specify what needs to be ignored in objects such as your PL/SQL scripts when the comparison is made. 
The most important tab is the first one "Object Types to Compare". The options tab has 4 nested tabs, each one allowing you to customize exactly which objects need to be compared. Under options select those objects that you wish to be compared. Define the target schema as well as the folders where all the output files will be stored. You can also choose any other valid connection you have in Toad. If you already have a connection open this will default to currently open connection. To use the Compare Schemas tool do the following: The object set allows you to define filters which will be used in selecting objects that need to be compared (useful if you use a standardized naming convention on your db objects). The second tab allows you to define what parts of the schema should be compared (tables, packages, etc). In the first tab you set up the schemas that will be compared. Toad allows you to compare 2 schemas using the Database Compare tool. What is that you are saying? You didn't? Oh! you forgot! No worries, Toad comes to the rescue. I hope you kept track of all the changes you made to your development database. Your production database is live and you need to merge your changes from development into production. 
The time has come to finally move all the awesome changes that you have made in your development database to a production database.
0 kommentar(er)
