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.
SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server
2012 (except SQL Azure)
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.
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
You can do everything in a familiar way: connect to as many server
instances as you like and browse all available databases.
A build-in text editor allows you to see the original object definition with syntax
highlighting, which facilitates reading of source code.
You can save every decrypted definition to a file with UTF-8 encoding,
which preserves all national characters.
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.
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.
SQL Decryptor performs everything asynchronously, thus you can instantly
cancel any long-term operation and you will never see the program hung.
Enjoy the glorious visual style of SQL Decryptor, which is similar to Visual
Need to generate lots of SQL test data?
Try dbForge Data Generator
If you are an SQL Server MVP,
send us a link to your Microsoft MVP profile and get a free
licence for any SQL Server product!
Awesome tool, Great when people don't check-in files to VSTS before committing them to the DB with encryption on.
You might be also interested in:
SQL Server management tools: