September 7, 2019 at 12:36 pm
Comments posted to this topic are about the item Compare data of two tables
Online Trainer For SQL DBA and Developer @RedBushTechnologies with 18 yrs exp.
September 23, 2019 at 11:42 am
Why not generate a hash byte and compare the two tables based on the join condition?
September 23, 2019 at 2:37 pm
CHECKSUM(*) or BINARY_CHECKSUM(*) could be an option but this needs all columns in the same order and (sometimes) equal data type.
Beside of this the function may work or a good starting basis, but has several flaws (e.g. no support for NULL columns; using the old INFORMATION_SCHEMA instead of the sys-schema; being not really well formated; no comments; using a global temporary table; not even trying to escape the table and column names (QUOTENAME() is your friend))...
God is real, unless declared integer.
September 23, 2019 at 3:09 pm
Also what about the Microsoft supplied tablediff! While BOL indicates this is a utility for comparing replicated tables it works quite nicely on any pair or table regardless of the method of the table duplication. Granted there are some bugs in early version of the utility but you can run newer version of the exe against older version of sql server
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply