Databass Compare

[sampath]

I want to compare two databases (same database name ) ex: 01/01/2012 customer database with 31/08/2012 customer database
to identify newly added changes like as follows

• fields
• tables
• indexes

is this possible or have any tool for do this ?

 

[jdpjamesp]

If you use the Data Administration tool you can connect the two databases and create an incremental .df file that will show you what changes would need to be applied to one database to bring it to the same level as the other one.

 

[dinesh1178]

You can dump the df for both databases and then do the diff on those files.