I have 2 tables each table has 45 million rows, I want to make sure the data are same in both the table, I did the row count and it's coming same for both the table, is there any other way i can make sure data are also same
RedGate does have a SQL Data Compare utility but it won't be fast on tables this size. Alternately, you could use the CHECKSUM function to compare the table values. Another approach, if you only want to assure that the second table is identical to the first, would be to truncate the second table and copy the first table into the second.
================================================= We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry