Welcome to the ApexSQL Decrypt general overview video. ApexSQL Decrypt is a SQL server development tool that can decrypt SQL objects from multiple SQL databases located on different SQL servers. Before decryption, the original DDL script can be previewed in the query window as the create or alter script type.
Decryption can be done directly on a database or by creating one SQL script for all objects or one SQL script per object. Along with the above mentioned, ApexSQL Decrypt can also decrypt SQL procedures, functions, triggers, and views. Decrypt objects with a single click. View original DDL scripts, decrypt databases from multiple servers, initiate decryption directly from SSMS, filter encrypted objects, export decrypted objects into a SQL script.
Preview and execute the decryption script from the integrated editor. ApexSQL Decrypt has two main components, GUI, a Windows-based application used for decrypting specific object types like procedures, functions, triggers, and views. SSMS add in, a SQL server Management Studio add in that allows the initiation of decryption of an object directly from SSMS with a right click on the desired object in the Object Explorer, then clicking on Decrypt Object.
Please note that SSMS add in is an optional component that can be selected or deselected during the installation of ApexSQL Decrypt in the integration step. Upon starting the application, the connect to SQL server window will be shown with the server and the authentication type options used to load the database for object decryption. Select the desired server and authentication type and click on Connect.
Once a server is loaded, by default, it will be expanded and all databases will be shown in the results grid. Additionally, servers can be added or removed from the results grid via the Add or remove buttons from the Home tab. Before continuing, let's review the options window, which can be initiated from the tools section of the Home tab once the Options button is clicked.
In the General tab of the options window, type of startup action and object filter options can be defined. The next tab is the Output tab, where the type of output format and editor can be chosen, along with the default output folder and type of encoding for the decryption script. The script tab allows the selection of various script options and includes the optional script elements that can be added to the decryption script.
Now that the options window is thoroughly explained in the options are set, let's get back to the results grid. Databases in the results grid can be expanded to show various object types that are encrypted in the currently selected database. Once the object is selected, the preview of the DDL script for that selected object in the Object script panel, which is located under the results grid.
Object filter can Additionally filter out the results in the results grid and also define the encryption state and the object types that will be included. For the purpose of this video and to easily spot encrypted objects, let's uncheck the unencrypted option under the encryption state section. By right clicking on the results grid, the context menu is shown from which various options can be chosen.
But in this example, the decrypt object's option will be used. The same action can be done by clicking on the Decrypt button located in the actions section of the Home tab once all the desired decrypted objects are selected in the results grid. This initiates the decryption wizard. In the output type step of the decryption wizard, the created decryption script or the Decrypt Now action can be chosen.
There are also additional options, like which statements will be used to script objects and the ability to create one SQL script for all or one per object. The last step of the decryption wizard is the action plan that shows which objects are selected for decryption before the process is finalized and the corresponding script is created. Once the Create Script button is clicked.
When the decryption process is done, the results window will be shown, along with all information messages about the taken actions. The execution results can be saved into four different output types, text file, word document, web page, and PDF. All selected objects are now decrypted with just a few clicks by using ApexSQL decrypt.
Thanks for watching. For more information, please visit apexsql.com.