My Blog

Optillect’s SQL Decryptor on cloud

1-click AWS Deployment 1-click Azure Deployment

Overview

Optillect SQL Decryptor is a straightforward and reliable application especially designed for database administrators who need to decrypt SQL procedures, views, triggers and other objects effortlessly.

There are situations when you need to secure your scripts against unauthorized users and encrypt object definitions in your database by using the ‘With Encryption’ option. When it comes to restoring your SQL scripts, you might run into some problems with your SQL Server so you won’t be able to recover your data and here is where Optillect SQL Decryptor comes in handy.

Optillect’s SQL Decryptor on cloud For AWS

Features

Major Features of  Optillect’s SQL Decryptor 

Support for all versions and editions of the Microsoft SQL Server
SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2011 (except SQL Azure)

Decrypts all possible object types
Stored procedures (including numbered procedures and replication filters), functions (scalar, inline and multistatement table-valued), triggers (on tables, on views, on databases, and on server instances) and views.

No DAC connection required
Similar tools compel you to use Dedicated Administrator Connection mode to decrypt an object, which may lead to certain diffuculties with reconfiguring the whole server. SQL Decryptor does not require this mode, but doesn’t prohibit to use it, because you can save some time while decrypting objects in large databases.

Object Explorer like in SQL Management Studio
You can do everything in a familiar way: connect to as many server instances as you like and browse all available databases.

Syntax highlighting
A build-in text editor allows you to see the original object definition with syntax highlighting, which facilitates reading of source code.

Saving definition to file
You can save every decrypted definition to a file with UTF-8 encoding, which preserves all national characters.

Batch decryption wizard
Decrypt all or particular objects with extra convenient and simple wizard, then save definitions to one or several files, or just alter database objects in-place.

Overhead minimizing
All definitions are placed to a program’s cache after first opening, so next time you want to examine the same definition, the cache will be used.

Highly responsive user interface
SQL Decryptor performs everything asynchronously, thus you can instantly cancel any long-term operation and you will never see the program hung.

Sophisticated appearance of Visual Studio 2010
Enjoy the glorious visual style of SQL Decryptor, which is similar to Visual Studio 2010

AWS

Installation Instructions For Windows

Note: How to find PublicDNS in AWS

Step 1) RDP  Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows  instance on AWS Cloud

1) Connect to the virtual machine using following RDP credentials:

  • Hostname: PublicDNS  / IP of machine
  • Port : 3389

Username: To connect to the operating system, use RDP and the username is Administrator.
Password: Please Click here to know how to get password .

Step 2) Click the Windows “Start” button and select “All Programs” and then point to Optillect’s SQL Decryptor

Step 3) Other Information:

1.Default installation path: will be in your root folder “C:\Program Files\Optillect\SQL Decryptor”
2.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443

Configure custom inbound and outbound rules using this link

Installation Step by Step Screenshots

 

 

 

 


 

 

Videos


Optillect’s SQL Decryptor on cloud