Comparing databases

#1

Is there any provision in DB2 to compare databases, something similar to
the diff operator in unix.

As I was not able to find any, i reverse engineered the databases into
ERwin and used the 'Complete Compare' feature of ERwin.

I have heard that oracle has such a tool called 'Change Manager'. anything
for db2?

Cheers,
San.

#2

shsandeep wrote:

Quote:

Is there any provision in DB2 to compare databases, something similar to
the diff operator in unix.

As I was not able to find any, i reverse engineered the databases into
ERwin and used the 'Complete Compare' feature of ERwin.

I have heard that oracle has such a tool called 'Change Manager'. anything
for db2?
Interesting you say that. I attended a talk on DB2 multiplatform at IM

Tech this week and the presenter noted that a change management tool
will be available soon. Not sure if it does what you want.
Today I'd look at the Rational tool set like
Rational Data Architect or Rational Application Developer for such a
feature.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

#3

Note sure if DB2 has a built-in tool for this, but I know a third party
tool that can do it. Go to http://synametrics.com/winsql

shsandeep wrote:

Quote:

Is there any provision in DB2 to compare databases, something similar to
the diff operator in unix.

As I was not able to find any, i reverse engineered the databases into
ERwin and used the 'Complete Compare' feature of ERwin.

I have heard that oracle has such a tool called 'Change Manager'. anything
for db2?

Cheers,
San.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Comparing databases

comp.databases.ibm-db2 comp.databases.ibm-db2

Comparing databases - 05-19-2006 , 12:23 AM

Re: Comparing databases - 05-19-2006 , 01:29 AM

Re: Comparing databases - 05-22-2006 , 04:19 PM