Frequently asked questions about SQL Shield

DbDefence - Truly transparent database encryption for MSSQL Server 2012, 2008 and 2005. DbDefence encrypts SQL Server database and hides schema from unauthorized access. From zero to 5 lines of code in your application!

Click here to download Free Version !

Testimonial:

We purchased XP_CRYPT and SQL Shield last year and are very pleased with stability and performance of your software. During this year we didn't have any problems with it. We are using those components in highly transactional environment available 24/7/365. Thanks for providing great software!

Marcello Savorani
Visual Computing s.r.l.
Italy

Frequently asked questions about SQL Shield:

Q: I've a basic question when you encrypt any SQL stored procedure with SQL Shield there is no way to decrypt it back ? let say if you want to modify the stored procedure how would you do that ?

The behavior of the stored procedure is the same like with the native encryption. Once you encrypted the procedure you can not edit it anymore. Only delete and restore can be applied. Of course, every software can be sooner or later cracked. The only difference is that unlike the Microsoft we can quickly upgrade the software to prevent decryption.

Q: Will SQL Shield work with MSDE?

Yes, it works with MSDE just like with SQL 2000

Q: Can you tell us what are the exact limitations of the free versions?

Free version of SQL Shield is only limited by the source size of the stored procedure. Not longer than 300 chars.

Q: Could you tell more detail about redistribution license ? How it is installed , how to distribute the database ? Do I need install software on my customer's computer ?

SQL Shield must be installed on every computer where encrypted procedures must run.

There are two possible ways:
You install SQL Shield at the client server and run the script which creates all database schema. Procedures marked with "WITH /*sqlshield*/ ENCRYPTION" will be encrypted using SQL Shield encryption.

The second way is to install it at your server, create encrypted procedures and then deliver database to the customer. But before attaching database you must install SQL Shield at the client's server.
Take a look at the example how SQL Shield works http://www.sql-shield.com/example.html

SQL Shield is licensed on per-server basis. This means the license must be purchased for every SQL Server where you install our software. Redistribution license allows you to install SQL Shield to your customers as a part of your own software without paying license for every server.