Results 1 to 10 of 10
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Complete Schema Compare

    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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You can use db2look to compare the DDL, -z option to specify the schema name.

  3. #3
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    ChangeManager:
    Database Change Management Software | Change Manager

    and they now have 30 days trials.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  4. #4
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Quote Originally Posted by aflorin27
    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

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    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.
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks,

    I am just searching Aqua

  7. #7
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    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

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What exactly does Aqua data studio do? Based on aquafold.com, it just compares DDL.

  9. #9
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    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

  10. #10
    Join Date
    Aug 2009
    Posts
    9
    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...

Posting Permissions

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