Optillect SQL Decryptor

Optillect SQL Decryptor is a straightforward and reliable application especially designed for database administrators who need to decrypt SQL procedures, views, triggers and other objects effortlessly.

There are situations when you need to secure your scripts against unauthorized users and encrypt object definitions in your database by using the ‘With Encryption’ option. When it comes to restoring your SQL scripts, you might run into some problems with your SQL Server so you won’t be able to recover your data and here is where Optillect SQL Decryptor comes in handy.

The application enables you to quickly select the procedures, triggers or scripts from multiple databases, then decrypt them.

When you launch the program for the first time, a small window appears that automatically recognizes the available SQL Server. After that, you can choose between Windows or SQL Server authentication modes, the connect to your databases.

The left panel displays all of the available procedures, functions, DML and DDL triggers, views and databases. You can easily navigate to the tables and procedures you want to decrypt and view their content by double-clicking them.

What’s more, Optillect SQL Decryptor comes with a decryption wizard that guides you through all the steps of the recovering process. The wizard can be easily accessed from the Action menu.

After choosing the output type and specifying the file path you want, the wizard automatically searches all the databases for specific procedures, user defined functions or table triggers. The Execute button enables you to decrypt all the selected database objects within seconds. Since it comes with batch support, you can decrypt as many procedures or functions you want.

Overall, Optillect SQL Decryptor proves to be a steady solution worth having when you need to restore specific SQL triggers, functions, views or procedures from multiple databases.