Hi All,
I need to check/validate customer data in two DB (prod & restored copy). Below are the fields i need to compare from Policyholder table in both DB's and i need to extract the data which are not identical. Table has more than 5m records. What is the efficient way to perform this task? Any reply will be greatly appreciated.
Thanks
Reagrds,
SG
,PolicyHolder.PolicyHolderId
,policyholder.Title
,policyholder.Firstname
,policyholder.LastName
,PolicyHolder.EmailAddress
,PolicyHolder.AddressLineOne
,PolicyHolder.AddressLineTwo
,PolicyHolder.AddressLineThree
,PolicyHolder.TownCity
,PolicyHolder.CountyState
,policyholder.PostcodeZip
,PolicyHolder.Country
,Policyholder.PhoneDaytime
,policyholder.PhoneEvening
PostcodeZip