Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aex
Yak Posting Veteran
60 Posts |
 Posted - 2009-02-11 : 02:22:07
|
| I have a problem here where I've deployed my database to remote client. Whenever I have upgraded version of my stored procedures, what I do now is creating a .bat file by using sqlcmd command to execute the upgraded SP to the database, and for this, I have to move my .bat together with the relevant SP to client side and execute for them.It poses no problem for me until my client request that they want to run the scripts themself for some reasons. I am in dilemma in that I don't want the client to know the working logic of my SP, which I worry the logic might be tampered as well. So I wonder if there is any tool that can wrap my SP (preferably an executable file) and my client just have to double click the executable file and won't be bothered by anything else, which at the same time the working logic is safe from being copied or manipulated.Thanks in advance for any reply.aex |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
aex
Yak Posting Veteran
60 Posts |
Posted - 2009-02-12 : 04:12:01
|
Ya, I was thinking to write my own application to encrypt the stored procedures. However, it is impossible most often time that I have sufficient time to create helper tools, which I have more major tasks to solve. Moreover, the tool needs to be tested well before it is ready to be used in real world deployment. I think this is what most developers would face,  Anyhow, after surfing for a day time, I found a tool called EasySQL, and it seems quite useful in solving this kind of issue. At the time of replying, I still don't see it provides any feature to encrypt the SP. Hopefully I would find a tool that will help.I am just wondering why SQL Server does not provide this very important feature after exist for many years. Its really kinda disappointing.aex |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Is there package to run and stored SP into DB?