News for hackers. Stuff that matters.

A comment on How to Check 2 SQL Tables Are the Same. Parent comment

Re:How to Check 2 SQL Tables Are the Same by amtamt on Friday July 28, 2023 @08:11AM (#36905709)
checksum and checksum_agg do not work for all data items, at least for SQL server "Noncomparable data types" for checksum and "null" for checksum_agg are show stopper.

Also, checksum/ checksum_agg do not seem like SQL standard functions. referring https://www.postgresql.org/docs/current/features.html and https://en.wikipedia.org/wiki/SQL:2023#New_features.

[ Parent | on HN ]
Re:How to Check 2 SQL Tables Are the Same by LeonB on Friday July 28, 2023 @11:01AM (#36907778)
I remember casting some types to varbinary and then using fn_repl_hash_binary() to generate the hashes.

And by “remember” I mean I wrote it down here so that I wouldn’t have to - https://til.secretgeek.net/sql_server/bulk_comparison_with_h...

[ Parent | on HN ]