General
What are the minimum Windows permissions required to install and use ApexSQL Decrypt?
Learn more about minimum Windows permissions required to install and use ApexSQL Decrypt on this link
What are the minimum SQL Server permissions required to use ApexSQL Decrypt?
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
What SQL Server objects can be decrypted by ApexSQL Decrypt?
ApexSQL Decrypt can decrypt the following SQL Server objects: DDL triggers, DML triggers, functions, procedures, and views
Can I filter SQL Server objects that will be decrypted?
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
What output types are available in ApexSQL Decrypt?
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
What script types are generated for decrypting objects?
Users can choose between CREATE and ALTER script types to decrypt objects
Can I decrypt specific object(s) without the need to go through the Decryption wizard?
Yes. Select desired object(s) in the Results grid and from the right-click context menu choose the Decrypt object(s) now option
Can I preview the original DDL script of the encrypted object?
Yes. You can preview the original DDL script in the Query window and you can choose between CREATE and ALTER script type
Can I decrypt only the selected object from SQL Server Management Studio?
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
Is there an option to back up a database before decrypting?
Yes. When the Decrypt now action is chosen in the Decryption wizard, you can check the Backup the database before the decryption option
SQL Server support
What SQL Server editions are supported?
ApexSQL Decrypt supports SQL Server Express, Standard, and Enterprise editions
What SQL Server versions are supported?
Microsoft SQL Server 2017, 2016, 2014, 2012, 2008, and 2005
What SQL Server Management Studio versions does ApexSQL Decrypt integrate in?
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
Can I integrate ApexSQL Decrypt into all available SQL Server Management Studio versions?
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)
Can I use ApexSQL Decrypt add-in with other ApexSQL add-ins?
Yes. It can be used alongside any other ApexSQL add-ins