The setup of MsSqlPGP consists of an installer wizard that copies the files of the product and actual registration of the Transact-SQL scripts and the .NET assemblies where they are implemented as used defined stored procedures.
The first part of the process is done through the setup installer wizard.
The second part can be done manually or through a Wizard style application started at the end of the Setup:
From the Database Install Wizard dialog – select the MS SQL Server® instance and the database where the scripts will reside:
After executing the Stored_Procedures.sql the product is available in the target database and the provided routines can be invoked from the target database as:
and from other databases as
[target database name].dbo.PGP_...
Manual setup of the T-SQL scripts
The manual registration of the Transact-SQL scripts provided by MsSqlPGP can be done by copying the [Installation folder]\Setup sub folder to a target server machine and modifying by hand the paths to the \Setup\Bin folder in the \Setup\Stored_Procedures.sql script.
Switch from Trial version to Production
The Uninstall just like the Setup can be done automatically through the Uninstall wizard or manually by hand.
The Uninstall wizard can be started through the Control Panel\Programs and Features by right clicking on MsSqlPGP entry and selecting Uninstall or by running [Setup folder]\Uninstall\unins000.exe. The Uninstall wizard will run a dialog that will allow you to remove the T-SQL scripts and assemblies of the product from the MS SQL Server® database where they were initially installed:
If you wish to make a manual uninstall, first run the [Setup folder]\Setup\Uninstall.sql SQL script against the target MS SQL Server® database from Microsoft SQL Server Management Studio or other tool that you use for T-SQL development. Then manually delete the folder where the product was installed.
This chapter discussed how to install, upgrade and uninstall DidiSoft MsSqlPGP against an MS SQL Server® database.