Data base comparision

Question

Hello ,

I have this requirement of comparing duplicate data between SAP and SQL DB .

SQL DB contains 100GB data and SAP data is downloaded daily which need to compared with SQL Data .

Currently it is taking time let 1 GB data pass through the workflow and to complete comparision . Is there a faster way to do this .

Thankyou.

praneshsapmm · Answer

Hello ,

Any suggestions for the above problem .

Thanks.

praneshsapmm · Answer

Hi @Luke_C ,

There are certain criteria to summerize even that takes a bit longer time .

Thanks.

Luke_C · Answer

Do you need to compare each and every record? Maybe you can summarize record counts based on key attributes and compare those first, for example both DBs have 1,000 records for ABC, 3,500 for DEF, etc. Then if there's a difference you can drill into it.