Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2012
    Posts
    3

    Unanswered: How can I compare two huge tables?

    I need to compare if two developers did the job correctly and created identical tables.

    The problem is more complex, but I will try to solve it somehow if I solve the problem of comparing two tables (let them be in different SQL Server 2008 databases) and their properties. No data needs to be compared.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Script out both tables, and compare the results? Are you just looking to confirm that the datatypes and names of the columns match? Or that they have the same indexes/constraints?

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Script both table's DDE.
    Print each to a separate sheet of paper.
    Place one sheet on top of the other.
    Hold sheets up to a light.
    If it's not practically useful, then it's practically useless.

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

  4. #4
    Join Date
    Aug 2012
    Posts
    3

    Talking

    Quote Originally Posted by blindman View Post
    Script both table's DDE.
    Print each to a separate sheet of paper.
    Place one sheet on top of the other.
    Hold sheets up to a light.
    Man, you are my new idol! Thanx!

  5. #5
    Join Date
    Aug 2012
    Posts
    3

    Lightbulb

    Quote Originally Posted by MCrowley View Post
    Script out both tables, and compare the results? Are you just looking to confirm that the datatypes and names of the columns match? Or that they have the same indexes/constraints?
    Yes, I need indexes/constraints checked too.

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Quote Originally Posted by RobertJung View Post
    Man, you are my new idol! Thanx!
    Oh, great. Now Blindman is going to have an ego flare up. ;-)

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Pegged the needle long ago MCrowley. Long ago...
    If it's not practically useful, then it's practically useless.

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

Tags for this Thread

Posting Permissions

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