Monday, February 29, 2016

How to compare schemas in different databases using Toad


Bring up toad and drill down the tab as shown below.





Select the source and target database for the schemas you want to compare.


Select the options as show in below with the schema name filter (like ‘ABC %’)





Select the options you want to compare between the schemas.


Select the output location/path with the below options…


Then you are now ready to execute (the green button). Once you run it will take few minutes depending on the number of objects to compare.


Hope this Helps...................






No comments:

Post a Comment

PostgreSql: Useful Commands-

 1)   ************************* Users ***************************  -- List of users with roles assigned: SELECT usename AS role_name,   CASE...