Tools for bulk decrypting various objects in SQL Server database Dbforge SQL decryptor

Source: Tools for bulk decrypting various objects in SQL Server database Dbforge SQL decryptor

Tools for bulk decrypting various objects in SQL Server database Dbforge SQL Decryptor2.1.11

Previously wrote an article using Redgate Company's SQL Prompt tool, but not very convenient

SQLPROMPT5.3 decryption tests on various cryptographic objects

SQL2005 decryption of stored procedures that have been encrypted

Yesterday Ahdung child shoes introduced this tool to me, thank him very much

Dbforge SQL decryptor The software company of this tool is Devart, is also the same as Redgate company, the production of a variety of database tools and programming tools of a more famous software company

Official website:http://www.devart.com/

Software:

Http://www.devart.com/dbforge/sql/sqldecryptor/download.html

Http://files.cnblogs.com/lyhabc/sqldecryptor.rar

This tool is free, do not crack, installation is complete, immediately can be used

Another free tool is available in SQL Server Database Tools: Dbforge SQL Azure Backup

http://www.devart.com/dbforge/sql/

Introduced

First off: You can put these third-party tools in the external tools, so as long as you open SSMs, you do not have to look for these tools on the desktop icon and then open

The corresponding tools, speed can be as fast as I do, I opened the ssms will not go to the desktop to find the software, find the software

The interface is written in WPF, and it's pretty good.

The login interface is very interesting, you can use a traditional connection, or you can use a DAC connection or write your own connection string

We follow this article to create a variety of cryptographic objects:SQLPROMPT5.3 decryption test for various cryptographic objects

including views, stored procedures, functions, triggers

The function is simple, the interface is similar to SSMS

Just three features

Select your database and right-click decryption Wizard.

He will list the types of decrypted objects you have chosen to display, respectively: stored procedures, user-defined functions, views, table triggers, database triggers

You can save the decrypted script of various objects into the same script or a script for each object, and I have chosen to save it in the same script.

When you click Execute, a script is generated on the desktop. sql file

Drag the script to SSMs

1  UsePratice2 GO3 4 SETANSI_NULLS, QUOTED_IDENTIFIER on5 GO6 /*************** Creating an encrypted stored procedure *******************/7 Create Procedurecpp_test_encryption8  withEncryption9  asTen ----can be replaced by arbitrary logic One Executecpp_test_original A GO -  - SETANSI_NULLS, QUOTED_IDENTIFIER on the GO - CREATE FUNCTION [dbo]. F_get_page (@page_num BINARY(6)) - RETURNS VARCHAR( One) -  withEncryption +  as - BEGIN + RETURN(CONVERT(VARCHAR(2),(CONVERT(INT,SUBSTRING(@page_num,6,1))*POWER(2,8))+ A(CONVERT(INT,SUBSTRING(@page_num,5,1))))+':'+ at         CONVERT(VARCHAR( One), -(CONVERT(INT,SUBSTRING(@page_num,4,1))*POWER(2, -))+ -(CONVERT(INT,SUBSTRING(@page_num,3,1))*POWER(2, -))+ -(CONVERT(INT,SUBSTRING(@page_num,2,1))*POWER(2,8))+ -(CONVERT(INT,SUBSTRING(@page_num,1,1))))) - END in GO -  to SETANSI_NULLS, QUOTED_IDENTIFIER on + GO - CREATE VIEWAA the  withEncryption *  as $ SELECT *  from [dbo].[Users]Panax Notoginseng GO -  the SETANSI_NULLS, QUOTED_IDENTIFIER on + GO A CREATE TRIGGERcc the  on [dbo].[Users] +  withEncryption -  for INSERT $  as RAISERROR(500001, -,Ten) $ GO -  - SETANSI_NULLS, QUOTED_IDENTIFIER on the GO - Create Procedurecreat_test_encryptionWuyi  withEncryption the  as - SELECT TOP  - *  from [dbo].[test13] Wu  - GO

and decrypt In-place (Alter objects) is to remove the various objects with encryption, do not know f_get_page this function will fail

Before performing decrypt In-place (Alter objects)

1 SETANSI_NULLS, QUOTED_IDENTIFIER on2 GO3 ALTER Procedurecreat_test_encryption4  withEncryption5  as6 SELECT TOP  - *  from [dbo].[test13]7 GO

After performing the execution of decrypt In-place (Alter objects)

1 SETANSI_NULLS, QUOTED_IDENTIFIER on2 GO3 ALTER Procedurecreat_test_encryption4  as5 SELECT TOP  - *  from [dbo].[test13]6 GO

You will see that after executing decrypt in-place (Alter objects), the equivalent of removing the with encryption

In addition to the user-defined function after the other decryption, in fact, you can drop the function, and then use the decrypted script to recreate the function can be

View, the trigger doesn't have a small lock icon

Other features

The show DDL script shows the object's creation script, and decrypt In-place I won't say it.

Note that the following interface is the interface in the Dbforge SQL decryptor tool, not the interface in SSMs, although the interface of this tool is much like the SQL2012 SSMs interface

Summarize

Once the DBA has this tool, it is not afraid that developers will be free to encrypt their own functions, stored procedures, triggers

can also relieve the DBA's burden.

If there is a wrong place, welcome everyone to shoot brick O (∩_∩) o

Tools for bulk decrypting various objects in SQL Server database Dbforge SQL decryptor