Hi All,

I need to compare schema in two DBs at workplace.

Can someone send me a script or utility or any documentation to compare schema in both databases.

Thanks
DBFinder

You can use db2look to compare the DDL, -z option to specify the schema name.

ChangeManager:
Database Change Management Software | Change Manager

and they now have 30 days trials.

They have 14 days trial.

I tried change manager which is piece of scrap.
After 33 minutes run it tells me that the tables do not exist on target.

I uninstalled it and now trying Schema Examiner.

If you have tried Change Manager successfully, Can you help generating Tables Comparasion report.
I tried my best since yesterday, it seems that I wasted time . The report was due this afternoon.


DBFinder

TOAD for DB2, Aqua Data Studio, and the IBM Rational Data Architect all have this feature. Of the three, I know for sure Aqua has a free trial. The Rational software used to have one, but they may have dropped it.

Thanks,

I am just searching Aqua

Aqua data studio worked well.

The report generated is in unicode html. SQLs could not be cut and pasted because it gives extra characters when pasted in plain text editor.
Otherwise comparison was good
thanks

What exactly does Aqua data studio do? Based on aquafold.com, it just compares DDL.

Bella,

Among many things it does, I only compared two Schemas in different DBs ( which we expect to be same or similar).

The report was nice (actually I compared only table and table related objects) in HTML format along with Sync SQL to sync table structures etc.

It was Unicode HTML format and SQL cut and paste inserts some odd characters in text. Over all Tables Compare was useful.

I will try to see what else it can do for a dba, this Monday.

DBFinder

Can anybody tell me, whether Aqua data studio creates an update script? So i want to compare Schema1 and Schema2 and i need a script that updates Schema1 to exactly the Schema2 without loosing the data in Schema1...