Setup
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:
dbo.PGP_...
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.
Upgrade
The upgrade process is automated and is equivalent to the Setup.
Switch from Trial version to Production
The upgrade from evaluation version to a fully functional production copy is done just like the Upgrade through the normal setup in the same database where the trial version resides.
Uninstall
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:
Manual uninstall
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.
Summary
This chapter discussed how to install, upgrade and uninstall DidiSoft MsSqlPGP against an MS SQL Server® database.
