Decrypt SQL Server Procedures, Functions, Triggers, and Views Easily

dbForge SQL Decryptor - Main Window

If you have encrypted an object definition in your database by specifying WITH ENCRYPTION option, and by some reason you cannot restore its original T-SQL body, the dbForge SQL Decryptor will easily do it for you absolutely free. Save your time and funds on restoring lost definitions and stay happy with our products.

Note: dbForge SQL Decryptor is developed for the sole purpose of decoding database source object DDLs for further modification. It cannot be used to break security keys, certificates, or passwords. Neither it grants unauthorized access to a database.

Features

Supports all versions and editions of Microsoft SQL Server

SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012 (except SQL Azure)

dbForge SQL Decryptor - Server Connection

Decrypts all possible object types

Stored procedures (including numbered procedures and replication filters), functions (scalar, inline and multistatement table-valued), triggers (on tables, on views, on databases, and on server instances) and views.

No DAC connection required

Similar tools compel you to use Dedicated Administrator Connection mode to decrypt an object, which may lead to certain difficulties with reconfiguring the whole server. dbForge SQL Decryptor does not require this mode, but doesn't prohibit to use it, because you can save some time while decrypting objects in large databases.

Object Explorer like in Microsoft SQL Server Management Studio (SSMS)

You can do everything in a familiar way: connect to as many server instances as you like and browse all available databases.

Syntax highlighting

A build-in text editor allows you to see the original object definition with syntax highlighting, which facilitates reading of source code.

Saving definition to file

You can save every decrypted definition to a file with UTF-8 encoding, which preserves all national characters.

dbForge SQL Decryptor - Decryption Wizard

Batch decryption wizard

Decrypt all or particular objects with extra convenient and simple wizard, then save definitions to one or several files, or just alter database objects in-place.

Overhead minimizing

All definitions are placed to a program's cache after first opening, so next time you want to examine the same definition, the cache will be used.

Highly responsive user interface

SQL Decryptor performs everything asynchronously, thus you can instantly cancel any long-term operation and you will never see the program hung.

Sophisticated appearance of Visual Studio 2010

Enjoy the glorious visual style of SQL Decryptor, which is similar to Visual Studio 2010

dbForge SQL Decryptor
Overview