I want to ship an 18.104.22.1686 *.db file to another party without any of the procedural code still visible to even a binary editor.
I can use ALTER ... SET HIDDEN but that just obfuscates and the recipient is rather clever.
I suspect DROP may not do much of anything to the system catalog data and extension pages other than mark them as free.
Should I use ALTER to replace every procedure, trigger, event, service etcetera with big fat meaningless templates, thus overwriting everything?
Or is that still not going to work?
asked 07 Oct '10, 19:30
These are two wild guesses:
1) Can you create a blank db and send only the data over to it? Ship the new "clean" db with the same data contents instead of the original with all the procedural code.
2) Can you unload the db and generate the reload statement then delete what you don't want in the reload and then reload? Ship the newly loaded "clean" db.
answered 07 Oct '10, 20:46