Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2005
    Posts
    24

    Unanswered: How can I compare two databases?

    I have two databases - I will call them database A and database B.

    I want to run some code on database A, and then check if database A became identical to database B.

    How can I compare two databases? I want to compare them in terms of structure, not content.

    Any suggestions? Thank you!

  2. #2
    Join Date
    Mar 2004
    Posts
    18
    there r couple of tools avialable in the market.
    Check Red Gate Tools

  3. #3
    Join Date
    Apr 2005
    Posts
    24

    Any free products

    Does anybody know such a product that is free...I find a couple of products but they have only 14 days free trial period. I need such a tool for longer time...

  4. #4
    Join Date
    Sep 2005
    Location
    Schaumburg, IL
    Posts
    28
    Quote Originally Posted by venetai
    Does anybody know such a product that is free...I find a couple of products but they have only 14 days free trial period. I need such a tool for longer time...
    Longer time? much better to make a program for that in that case. VB or something.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    If the databases are on the same server, then compare the sysobjects, syscolumns, and other system tables between the two using a full outer join on the natural keys, and listing any exceptions or discrepancies.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Sep 2003
    Posts
    364
    Here's the poor mans way...

    Generate a db script in EM for both databases. Then compare both text files.

Posting Permissions

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