Blob comparison tool between two database
Hi,
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.
Thanks
Hari
Areteans
IN
Hi Harinath,
DB Solo can help in comparing Table Data between teo different Databases.
Please refer below link for more details,
http://www.dbsolo.com/help/datacomp.html
Luxoft
IN
Hi Devab,
Thanks for the information. Have read this information from google. Wanted to know if this tool is being used by pega for the blobs comparison.
Regards
Hari
Pegasystems Inc.
IN
There is no OOTB process to do so. You need to use third party tools / extesnions.
Check out this wiki to know more about it.
Luxoft
IN
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.
Branch Banking and Trust Company
US
Not sure what you are trying to compare but if it is small set of embedded columns in BLOB. you could use BIX Extracts