Search code examples
sql-serverwindows-installerinstallshield

Exporting .sql file from MSI

I have an MSI file that contains several .sql script files, can anyone tell me if it is possible to extract these file and look at the content. I tried using orca to export the ISSQLScriptFile table, but the files were exported as .sql.ibd, which is useless.

Thank you!

Solution

  • I haven't looked at this in a long time but as I recall it's all encrypted.

    https://community.flexerasoftware.com/showthread.php?188927-Extract-packed-script-sql-from-msi

    "For security, the script is encrypted and then stored in the MSI package."

    Someone then mentions that you can intercept the SQL files from a temp directory while the installer is running.

    MichaelU could weigh in if this is still true and if there are any other work arounds.