comparing schema in db2

oracle10gsingh · #1 (**permalink**) 07-30-10, 09:13

Dear All,

I am new to db2 ..and i want to compare 2 schema's like objects there in x schema not there in y schema and object datatype there x schema different in y schema ...can someone provide me the sql .how to do it ?

ARWinner · #2 (**permalink**) 07-30-10, 09:36

Use the catalog tables (syscat).

Andy

oracle10gsingh · #3 (**permalink**) 07-30-10, 09:39

can you provide me SQL ....

stolze · #4 (**permalink**) 08-02-10, 04:02

What exactly is the problem you're facing? You just have to join a couple catalog tables and apply the predicates.

nvk@vhv · #5 (**permalink**) 08-03-10, 04:22

Hi,

have a look at the Aqua DataStudio. This Tool has a utilty to compare Schemas in a database:
Database query tool - Aqua Data Studio is the query analyzer that works with Oracle, DB2, Sybase, MySQL and more.

Cheers
nvk

Internet Services

Web Development

Digital Marketing

Consumer Tech