Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: Database compare

    Hi ,

    We need to compare two databases from two different server. I tried generating database DDL using db2look and then using UNIX 'diff' command to check for the differences. But its giving me whole lot of differences even though there is a blank line in between.

    Any suggestions.

    Thanks in advance
    j

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I do not know of any specific tool that will do what you want. You could try to do the following:

    From your two databases A & B:

    Generate a third DB (C) from the DDL of A.
    db2move from B to C. If there are no errors, then A & B are the same.

    HTH

    Andy

  3. #3
    Join Date
    Apr 2003
    Posts
    191

    Re: Database compare

    Hi,

    3rd party tools like Powerdesigner DataArchitect should be able to compare two physical data models after reverse engineering from an odbc data source.

    db2look does not lend itself well for diffing, unless you slice the statements into paragraphs, convert those paragraphs to one liners, sort them and then do the diff.

    Another option would be to compare the system catalogs, if you just look for tables or indexes etc.

    Johann

    Originally posted by jfkuser
    Hi ,

    We need to compare two databases from two different server. I tried generating database DDL using db2look and then using UNIX 'diff' command to check for the differences. But its giving me whole lot of differences even though there is a blank line in between.

    Any suggestions.

    Thanks in advance
    j

  4. #4
    Join Date
    Jun 2003
    Location
    Canada
    Posts
    37

    Re: Database compare

    You could try WinSQL by Synametrics (http://www.synametrics.com/Synametri...p/Products.jsp) or, if you are willing to spends some $$$, try ErWin or DBArtisan.

    Cheers,

    Julius

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Database compare

    You need WinSQL professional to use the database diff feature ...

    If this is a one time requirement, yes, you can download a fully functional verison of winsql professinal and use the feature ... If not, it will cost $$s but less than many other tools

    Cheers
    Sathyaram

    Originally posted by jsasvari
    You could try WinSQL by Synametrics (http://www.synametrics.com/Synametri...p/Products.jsp) or, if you are willing to spends some $$$, try ErWin or DBArtisan.

    Cheers,

    Julius
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •