Home › Discussions › Questions & Answers › Migration Validation: Report Comparison Between Test and Prod

Migration Validation: Report Comparison Between Test and Prod

Avatar photoCustomer Questions & Answers 5 replies

We need to compare the definition of all Blitz Reports, including their main SQL text, between our local database and a remote database server after a migration. Which report facilitates this comparison?

5 replies

  • Support Enginatics

    Use the Blitz Report Comparison between environments report. It shows Blitz Report differences between the local and a remote database server.

  • What prerequisite must be met on the remote environment to prevent the `ORA-64202: remote temporary or abstract LOB locator is encountered` error when comparing large SQL text?

  • Support Enginatics

    You must create a specific view (`xxen_reports_v_`) on the remote environment that uses `dbms_lob.substr` to handle large object (LOB) columns like `sql_text_full`, converting them to a shorter string before the comparison.

  • Are there specialized comparison reports for parameters and LOVs as well?

  • Support Enginatics

    Yes. Use the Blitz Report Parameter Comparison between environments report for parameter differences and the Blitz Report LOV Comparison between environments report for LOV differences.

  • You must be logged in to reply to this post.