Home › Discussions › Questions & Answers › Importing Discoverer SQL with Minimal Modification

Importing Discoverer SQL with Minimal Modification

Avatar photoCustomer Questions & Answers 5 replies

We require the imported Discoverer SQL to maintain its original structure as much as possible, even if it’s messy. How do I prevent Blitz Report from applying code enhancements during conversion?

5 replies

  • Support Enginatics

    You should set the profile option ‘Blitz Report Discoverer Import Preserve Original SQL’ to ‘Yes’. This turns off Blitz Report’s additional structural code enhancements when importing and converting Discoverer worksheet SQLs.

  • What is the trade-off of setting this profile to ‘Yes’?

  • Support Enginatics

    While this makes the import more robust, the converted SQLs will be less ‘pretty’.

  • Is this recommended for troubleshooting difficult migrations?

  • Support Enginatics

    Yes, preserving the original SQL can make troubleshooting easier, as there are fewer changes introduced by the conversion engine.

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