Black Friday is here! Get up to 30% off on Devart products!

ends in {{days}}

{{timeFormat.hours}}

{{timeFormat.minutes}}

{{timeFormat.seconds}}

- Back to Main menu
  
  Back to Products
  Product finder
- Back to Main menu
- Back to Main menu
- Back to Main menu

- Back to Main menu
  
  Shopping Cart
  
  Your cart is currently empty
  
  Add product
Sign in
Contact Sales

Contact Sales

Product finder

Decrypt SQL Server Procedures, Functions, Triggers, and Views

SQL Server stored procedures, views, functions, and triggers may be created with the WITH ENCRYPTION option to encrypt the definition of the specific object. dbForge SQL Decryptor is a free tool that can help you view and decrypt the encrypted stored procedures, views, triggers, and functions in a quick way. To make it easy and efficient to work with the encrypted objects, use a highly responsive UI, syntax highlighting, Unicode support, a batch mode, decryption caching, output options, and other capabilities.

Restore the original T-SQL body if the primary source script file has been lost
Get rid of the encryption option which makes no sense due to weak protection
Save decrypted objects to one or several files
Alter database objects in-place in an SSMS-like SQL editor
Connect to the local & remote server with no need using DAC mode
Preserve all national characters while decrypting stored routines
No need to have any T-SQL scripting knowledge thanks to point-and-click decryption
View DDL scripts of stored routines with syntax highlighting

Features

Decrypt all possible object types

dbForge tool allows you to decrypt the following SQL Server database objects:

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
Views

Decrypt all possible object types

No DAC connection is required

Similar tools compel you to use a Dedicated Administrator Connection (DAC) mode to decrypt an SQL Server database 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.

No DAC connection is required

SSMS-like Object Explorer

View the DDL script as the CREATE statement in the SQL query document
Connect to as many server instances as you need
Work in two authentication modes: Windows Authentication and SQL Server Authentication
Display a DDL script of the selected database object
Use the Decryption Wizard to decrypt SQL server database objects

Decrypt and encrypt SQL Server database objects in SSMS-like Object Explorer

Syntax highlighting

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

Syntax highlighting displays the code and comments in different colors according to the group of components.

SQL Decryptor displays code with syntax highlighting

Saving DDL to file

With dbForge SQL Decryptor, you can easily save every decrypted definition to one of the following output files with UTF-8 encoding, which preserves all national characters:

Single T-SQL script file to save objects to a separate .sql file
T-SQL script file per object where each selected object will be stored in a separate .sql file
Decrypt in-place (alter objects) to decrypt objects on the server in order to work with the object in SSMS

SavE decrypted data to a file

Batch decryption wizard

The convenient Decryption wizard allows you to do the following:

Perform the decryption in bulk
Specify a path of the output file to store the decrypted definitions
Alter database objects in-place
Select database objects to decrypt
Search for encrypted objects in a database
Filter encrypted objects by object type

Perform decryption actions with the encrypted SQL Server database objects in bulk

Get Started with dbForge SQL Decryptor at no cost

Download for free and see how much time you save on decrypting encrypted SQL Server stored procedures, views, functions, or triggers.

Download free

Try the latest version of dbForge Studio for SQL Server

Manage schema and data diffs, perform complex database tasks, generate test data, design databases, compare databases, and much more!

Purchase now

Try SQL Tools with SQL Decryptor included

Sync schemas, deploy from version control, write SQL, refactor code, run unit tests, and more with our mega pack of SQL Server tools.

Find out more

Get More FREE Products