Professional Web Applications Themes

Easiest way to compare schemas of two database. HOW??? - IBM DB2

Hi, I need to compare schema (tables, fields, indexes, triggers) between two databases. Does IBM have any tool to do that? Best regards, K...

Sponsored Links
  1. #1

    Default Easiest way to compare schemas of two database. HOW???

    Hi,
    I need to compare schema (tables, fields, indexes, triggers) between
    two databases. Does IBM have any tool to do that?

    Best regards,
    K
    Sponsored Links
    Kathy Baytes Guest

  2. #2

    Default Re: Easiest way to compare schemas of two database. HOW???

    Hi,
    I don't know if IBM has a tool but I have used WinSQL
    ([url]http://www.indus-soft.com[/url]) and it works fine.

    Another alternative, if you are willing to spends some $$$ is to use
    ErWin or DBArtisan)

    Mark



    Kathy Baytes wrote:
    > Hi,
    > I need to compare schema (tables, fields, indexes, triggers) between
    > two databases. Does IBM have any tool to do that?
    >
    > Best regards,
    > K
    Mark Benson Guest

  3. #3

    Default Re: Easiest way to compare schemas of two database. HOW???

    Advanced Query Tool at [url]http://www.querytool.com/[/url] has a feature to
    compare schemas between two databases. This can be done with just a
    few clicks. The compare includes tables and columns but doesn't (yet)
    include indexes and triggers.

    Phil Castle.


    [email]nntpreader[/email] (Kathy Baytes) wrote in message news:<5028fd2.0306280726.3f494c9fposting.google.c om>...
    > Hi,
    > I need to compare schema (tables, fields, indexes, triggers) between
    > two databases. Does IBM have any tool to do that?
    >
    > Best regards,
    > K
    Phil Castle Guest

  4. #4

    Default Re: Easiest way to compare schemas of two database. HOW???

    Try IBM Data Studio, you can select any 2 objects and compare between them

    http://amir-shenodua.blogspot.com/2012/07/comparing-db2-objects.html
    Amir Guest

Similar Threads

  1. Using flash to validate XML with Schemas
    By tomeanand@hotmail.com in forum Macromedia Flash Data Integration
    Replies: 1
    Last Post: March 11th, 10:58 PM
  2. Easiest way to integrate flash a database
    By Weezy77 in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: February 8th, 09:48 AM
  3. cleanup of pg_temp schemas
    By Marcel Gsteiger in forum PostgreSQL / PGSQL
    Replies: 2
    Last Post: January 26th, 03:58 PM
  4. Schemas they say ...
    By HG in forum ASP.NET Web Services
    Replies: 7
    Last Post: November 18th, 10:47 PM
  5. Easiest Code for Database Paging
    By M P in forum ASP Database
    Replies: 2
    Last Post: March 3rd, 09:29 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139