Decrypt SQL Server procedures, functions, triggers, and views

dbForge SQL Decryptor is a free tool that helps you view and decrypt encrypted stored procedures, views, triggers, and functions. With a highly responsive UI, syntax highlighting, Unicode support, batch mode, caching, and other capabilities, dbForge SQL Decryptor allows you to perform tasks quickly and conveniently.

  • Restore the original T-SQL body without the primary source script
  • Save decrypted objects to one or several files
  • Alter database objects in-place in an SSMS-like SQL editor
  • Connect to local and remote servers with no need to use the DAC mode
  • View DDL scripts of stored routines with syntax highlighting
Includes dbForge SQL Decryptor
Get the ultimate bundle of SSMS add-ins
dbForge SQL Tools
dbForge

SQL Tools

Download the full dbForge SQL Tools bundle – 15 standalone tools and add-ins for SSMS and Visual Studio.

DEVELOP SQL TWICE TO FOUR TIMES FASTER
dbForge SQL Complete
dbForge

SQL Complete

Context-aware SQL completion, instant formatting, and advanced refactoring for SSMS and Visual Studio.

Features

  • No-DAC connection

Decrypt all possible object types

dbForge SQL Decryptor 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, views, databases, and server instances
  • Views
Get the free tool

No DAC connection is required

Decrypting tools often require a Dedicated Administrator Connection (DAC) mode to decrypt an SQL Server database object, which may need server reconfiguration.

dbForge SQL Decryptor does not require the DAC mode, however, it supports it, thus allowing you to save time while decrypting objects in large databases.

Get the free tool

SSMS-like Object Explorer

dbForge SQL Decryptor's Object Explorer is similar to that in SQL Server Management Studio, allowing you to perform multiple tasks in a familiar environment:

  • 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
Get the free tool

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.

Get the free tool

Saving DDL to a 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
Get the free tool

Batch decryption wizard

The convenient Decryption Wizard supports multiple database tasks:

  • 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
Get the free tool

Get more free SQL Server tools

dbForge

Event Profiler

dbForge Event Profiler

Capture and analyze SQL Server events in trace files to optimize performance

Download for free
dbForge

Monitor

dbForge Monitor

An add-in for SSMS that allows you to track and tune SQL Server performance

Download for free
dbForge
Search
dbForge Search

Locate database objects and table data across your databases directly in SSMS

Download for free

Leading companies choose dbForge SQL Tools

Berkley
Arconic
Polaris
Jabil
Hewlett Packard Enterprise
Lam Research
Microsoft

Reviews from our customers

G2

"Simple and free decryption of database objects. Sometimes, third party apps have databases with encrypted objects. Sometimes, I need to performance tune or track down an issue and I need to see inside those objects. SQL Decryptor lets me do that very easily."

Greg G.

SQL Database and Business Intelligence Manager, Mid-Market (51-1000 emp.)

G2

"A helpful tool! Before knowing dbForge SQL Decryptor I never encrypted my stored procedures in SQL Server and those I encrypt saved an unscrambled backup. You can remove encryption from a complete MS SQL database, supports Dual Login Mode: Windows & SQL Server Authentication and more."

Luis Geraldo C.

Ingeniero de desarrollo de software, Ingeniero Informatico de Preventa y Consultor de Soluciones IT, Small-Business (50 or fewer emp.)

G2

"Database safe tool. It decrypts encrypted stored-procedures, views, functions highly responsive UI. Till now I didn’t found any dislike it is very helpful to all developers."

Nidhi R.

Intern, Computer Software, Small-Business (50 or fewer emp.)

G2 Users Love Us
Software Suggest User Experience Excellence 2025
Crozdesk Quality Choice Award

Frequently asked questions

Can the tool decrypt objects created using WITH ENCRYPTION without requiring DAC?

Yes. dbForge SQL Decryptor does not require using the Dedicated Administrator Connection (DAC) mode for decrypting database objects. You can use the DAC mode if it is enabled, but it is not necessary.

What object types are supported?

dbForge SQL Decryptor can decrypt all database object types, including all kinds of stored procedures, functions, triggers, and views.

Does dbForge SQL Decryptor integrate into SSMS/Visual Studio or run as a standalone app?

dbForge SQL Decryptor runs as a standalone tool.

Is batch decryption available across databases/schemas?

Yes, there is a batch decryption mode in dbForge SQL Decryptor that allows you to perform bulk decryption across multiple schemas or entire databases with flexible configuration and filtering.

Can I alter decrypted objects in place, or only export scripts?

dbForge SQL Decryptor offers an option to alter objects in place.

What export options exist (single script, per-object files, re-encrypt option)?

Several export options are available. You can save multiple decrypted objects to a single T-SQL file or save each object as a separate T-SQL script file. Also, you can decrypt objects directly on the server to continue working with those objects in SSMS.

How is licensing handled (free vs paid), and what’s the total cost of ownership?

dbForge SQL Decryptor is a free tool. Also, it is available as part of the dbForge SQL Tools bundle. This bundle contains both free and paid solutions, but the functionality of the Decryptor does not depend on the status of the rest of the solutions in the bundle; it will work with no functional limitations.

Are there known limitations (numbered procs, replication, large schemas)?

No. dbForge SQL Decryptor works with all types of objects and efficiently handles decryption tasks even in massive databases. The SSMS-like Object Explorer helps you master the tool quickly, and such options as batch decryption with visual configuration and syntax highlighting simplify the tasks effectively.