CODEWITHSUNDEEP
sql-serverwindows-installerinstallshield
Aaron
Aaron

Reputation: 79

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!

Upvotes: 1

Views: 500

Answers (2)

PhilDW
PhilDW

Reputation: 20790

Assuming that the files are inside the MSI file in the sense of being in the internal CAB file, then do an "administrative" install, which is not an install at all. A typical command would be:

msiexec /a [path to msi file] TARGETDIR=[path to a folder where the files will go]

It extracts all the separate files to that location.

Upvotes: 0

Christopher Painter
Christopher Painter

Reputation: 55601

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.

Upvotes: 1

Related Questions