patternsqlMinor
Compile TSQL stored procedures into assembly
Viewed 0 times
storedprocedurestsqlcompileintoassembly
Problem
I am trying to protect my business logic and I don't want to use "With Encryption" as it is not enough and can be broken.
I don't want to re-write the procedures again in CLR language.
Is there an easy way to compile the TSQL programming into a DLL that can be used by SQL server, just like the same way it uses the CLR assemblies?
I don't want to re-write the procedures again in CLR language.
Is there an easy way to compile the TSQL programming into a DLL that can be used by SQL server, just like the same way it uses the CLR assemblies?
Solution
No, there is no way to do this. And there is not much purpose in doing so anyway as you can easily decompile Assemblies with tools such as ILSpy.
The two ways to protect your intellectual property are:
-
Proper license agreement. Consult with a lawyer to see what is best for you. There are many options and laws vary by state / region / country / etc so advice you get online might not be correct for you.
-
Innovation. Even if you protect the code from being seen, it can still be reversed engineered by observation / testing. Keep evolving and improving.
-
Yes, this is now more than 2, but this one isn't exactly protecting the intellectual property, BUT... Support: provide great support and that will help in some cases. Provide good, thorough documentation and fix things as quickly as possible when someone identifies a bug. This is harder to duplicate than code ;-).
The two ways to protect your intellectual property are:
-
Proper license agreement. Consult with a lawyer to see what is best for you. There are many options and laws vary by state / region / country / etc so advice you get online might not be correct for you.
-
Innovation. Even if you protect the code from being seen, it can still be reversed engineered by observation / testing. Keep evolving and improving.
-
Yes, this is now more than 2, but this one isn't exactly protecting the intellectual property, BUT... Support: provide great support and that will help in some cases. Provide good, thorough documentation and fix things as quickly as possible when someone identifies a bug. This is harder to duplicate than code ;-).
Context
StackExchange Database Administrators Q#175181, answer score: 8
Revisions (0)
No revisions yet.