ApexSQL Decrypt 2017 – Screen shot tour

ApexSQL Decrypt has three main menu tabs:

Once the application is run, the Connect to SQL Server window is shown to choose a server and load databases for object decryption:

After all databases are loaded encrypted objects can be viewed in the Results grid:

Preview of the original DDL script of selected encrypted object can be seen in the Object script panel:

Results grid can be filtered using the Object filter panel on the left side:

Checked encrypted objects can be decrypted from the right-click context menu in the Results grid, using the Decrypt objects option:

Multiple servers with corresponding databases can be loaded in the same Results grid with a click on the Add button under the Servers group in Home tab or from the right-click context menu in the Results grid:

When the Options window from the Home tab is opened, the General tab with application specific options is shown:

Under the Output tab, file locations along with different editors can be set, and different encoding can be specified for the decryption script:

Under the Script tab, Script options and Optional script elements can be set for the decryption script:

After all desired encrypted objects are checked and the Decrypt button from the Home tab is clicked, the first step in Decryption wizard is shown:

Beside setting up the Acton that will be done under the Output type step, script Granularity can be also specified:

In the second and last step of the Decrypt wizard, the Action plan can be reviewed before creating the decryption script:

Additionally, ApexSQL Decrypt supports SQL Server Management Studio integration. Here is the main menu of ApexSQL Decrypt:

In order to decrypt an object from SQL Server Management Studio, go to Object Explorer, right-click the encrypted object and choose the Decrypt object command from the context menu:

Once the decryption process is finished, the following message will be shown:

April 4, 2017