troubleshooting Question

How would I compare two SQL databases to see what may have changed during an application upgrade?

Avatar of Kathleen Klosterman
Kathleen KlostermanFlag for United States of America asked on
Microsoft SQL ServerSQL
3 Comments2 Solutions98 ViewsLast Modified:
We are performing an upgrade to an application, and I need to compare the original SQL db to the upgraded db to see what has changed. How would I do this? Not sure of the best way. Is there something like a table compare or maybe at the very least do a record count of the original db, then a record count of the upgraded db. (That wouldn't give me WHAT changed, but just that there might be a different number between the two databases.)  We are a small place and have no DBA.  I am an IT person who knows a little about SQL.  What is the best way to figure out what's changed?

Thank you!
ASKER CERTIFIED SOLUTION
OMC2000

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros