Thursday, March 29, 2012

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,

Alex8675Anybody 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.

No comments:

Post a Comment