SQL Server hash function on table that represents the complete data on that table?

Question

I need to get the hash function on the particular table that represents 1 million records in that table that is running on DB server A. so that I can compare this particular hash function with another hash function for the same table that is running on DB server B to check the data in that particular tables is same on both DB servers.

I don't know whether the right way to do it to compare the data on the same tables on different DB servers? please suggest if I'm in the wrong direction.

score 1 · Accepted Answer · answered Mar 18 '21 at 03:44

1

You cannot get HASH for whole table. But, you can get at row level. You can take the primary key and see if the hash is matching between two tables.

There are many functions to support this:

They are accurate, but in extreme cases, it can be wrong. Read this SO post

But, for comparing these two tables, you can create linked server and use EXCEPT clause to see, if data are different.

There are many ways to compare table data. Refer to this post: https://www.mssqltips.com/sqlservertip/2779/ways-to-compare-and-find-differences-for-sql-server-tables-and-data/

answered Mar 18 '21 at 03:44

Venkataraman R

12,181
2
31
58

Thank you for you're response. It did worked. sorry I missed to respond back. – Dev9321 May 12 '23 at 00:10
@Dev9321, Glad it helped. Please mark it as answer, so it will be helpful for future visitors of the site. – Venkataraman R May 12 '23 at 05:18
@Dev9321, click the tick mark to mark as answer. – Venkataraman R May 12 '23 at 05:19

SQL Server hash function on table that represents the complete data on that table?

1 Answers1