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
- 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:
By default, the only encrypted objects will be loaded on startup
- All objects
- Encrypted only
- Object filter:
By default, all objects are checked and will be loaded on startup
- DML triggers
- DDL triggers
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 Management Studio versions does ApexSQL Decrypt integrate in?
ApexSQL Decrypt integrates into Microsoft SQL Server Management Studio versions 2012 and higher.
You can use full-featured SQL Server Management Studio 2016 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
Does ApexSQL Decrypt support Azure SQL Database or SQL Server on Amazon RDS?
Yes. ApexSQL Decrypt supports Azure SQL Database V12 and higher and SQL Server on Amazon RDS
Can I connect to different SQL Server editions when creating a decryption object list?
Yes. You can connect to any of SQL Server editions or Azure SQL Database server or SQL Server on Amazon RDS, and create a decryption object list by combining any of these servers