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