Systems Administrator

Kathleen Klosterman

<div>
My comment contains the full answer with two directions of the problem resolution. The second comment just repeats my comment in other words and does not bring any extra value to the question
</div>


My comment contains the full answer with two directions of the problem resolution. The second comment just repeats my comment in other words and does not bring any extra value to the question

<div>
<div class="content wysiwyg-content">
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.) &nbsp;We are a small place and have no DBA. &nbsp;I am an IT person who knows a little about SQL. &nbsp;What is the best way to figure out what's changed?<br />
<br />
Thank you!
</div>
</div>


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!

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.