Would like to know is there any tool to compare blob columns between two tables in two different database.
Say for example if i have case in work table in mssql database and i have migrated the same case to work table in oracle database. i can validate exposed column types and data in the work tables between two database to make sure data is the same. But is there a way to validate blob columns? Dont want to open the case in both the application to compare the fields. Let me know if there is any OOTB tool or third party tool to compare and validate blob columns.
Understand that there is no OOTB process but wanted to know if pega uses any internal tool for blob comparison or pega can suggest tool that an be used. Since the blob value is compressed and stored, will the blob of same value stored in two different database be same when compared using third party tools.