ApexSQL Decrypt FAQ

The minimum permissions required to decrypt SQL objects are:

• Public role membership on SQL instances
• Connect
• View definition, and
• Select on databases that you want to decrypt

In addition to the above:

• Control has to be granted on the database, to execute the decrypt script

ApexSQL Decrypt can decrypt the following SQL Server objects: DDL triggers, DML triggers, functions, procedures, and views

Yes. You can filter SQL Server objects in two ways and both of them are available under the General tab in the Options window, from the Home tab:

Load objects on startup:

• All objects
• Encrypted only

By default, the only encrypted objects will be loaded on startup

Object filter:

• DML triggers
• DDL triggers
• Procedures
• Functions
• Views

By default, all objects are checked and will be loaded on startup

There are three output types in ApexSQL Decrypt:

• Decrypt now – SQL objects are decrypted directly on the database
• Create a decryption script:

  Create one SQL script – one SQL script will be generated for all encrypted SQL objects

  Create one SQL script per object – each encrypted SQL object will have each own SQL script

Users can choose between CREATE and ALTER script types to decrypt objects

Yes. Select desired object(s) in the Results grid and from the right-click context menu choose the Decrypt object(s) now option

Yes. You can preview the original DDL script in the Query window and you can choose between CREATE and ALTER script type

Yes. You can right-click the encrypted object in Object Explorer and click the Decrypt option. It will decrypt the selected object without opening the standalone application

Yes. When the Decrypt now action is chosen in the Decryption wizard, you can check the Backup the database before the decryption option

Microsoft SQL Server 2017, 2016, 2014, 2012, 2008, and 2005

ApexSQL Decrypt integrates into SQL Server Management Studio 17, 2016, 2014, or 2012
You can use the latest full-featured backwards compatible SQL Server Management Studio for free. Click here

Yes. During the installation of ApexSQL Decrypt you can choose whether to integrate it into all available SQL Server Management Studio versions or just into a desired one(s)

Yes. It can be used alongside any other ApexSQL add-ins