Use ARAXIS tool with which you need to do some work [extracting SQLs using db2look]
or use winsql [http://www.synametrics.com]
Good luck
Partha


-----Original Message-----
From: SaiPrasad
[mailto:db2udbdba-ezmlmshield-x44549174.[Email address protected]
Sent: Tuesday, November 30, 2004 11:03 AM
To: LazyDBA Discussion
Subject: Schema compare


Hi pals,
I am using DB2 ver 8.1 in AIX server

I have one schema which is a old one and a other schema with changes made
in old one.

How to compare both the schemas .
I need to produce a SQL script which is a difference of both the schemas.

Thanks In Advance

Rgds
saiprasad


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page