Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    46

    Unanswered: Database Comparison

    I had an application go down yesterday...it was giving a Type Mismatch error and the support team couldn't figure it out.

    My suspicion is that a field in the database got populated with a character the vb app didn't like when it renders the information.

    I'd like to prove that theory...but the database is large (4gb) and I'm not sure how to do a database comparison to see where the records differ.

    Anybody have a script to get me started OR some experience to share?

    Thanks,

    Alex8675

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Anybody have some real, useful, practical information that could help us figure out what your problem is?

    Exact text of error?
    DDL of table?
    Datatype of column?

    We are not mentalists, here. We don't play guessing games.
    If it's not practically useful, then it's practically useless.

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

Posting Permissions

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