SQL Server Upgrade

Step 01> From the installation directory, open the SQLServerCapabilies.sql file in a text editor.

Step 02> The highlighted part of the SQLServerCapabilities.sql file in the picture above sets the name for the database to be updated. Change this name from dekho if required.

Step 03> Click File and Save, to save the changes of the SQL file.

Step 04> If you have the SQL Server Management Studio installed, double click the SQLServerCapabilities.sql file to launch it, and run the script from within this application, otherwise, the SQL can be executed with the command line interface sqlcmd, using the following steps

Step 05> Open a Command window; click Start and Run.

Step 06> Enter cmd and press OK.

Step 07> Change to the install directory, and enter the command

sqlcmd i SQLServerCapabilities.sql o capabilities.txt w 132

Step 08> The resultant output from running this command is a text file capabilities.txt outlining all maps and their assigned capabilities (queries, reports, etc), as configured in your existing Dekho 2.x configuration. This text file will be used as a guide to re-establish these capability linkages once the maps have been reconfigured for Dekho 3.0.

Step 09> Repeat the previous steps 1 through 7 for the SQL script SQLServerRoles.sql, if utilising the sqlcmd approach use the command:

sqlcmd i SQLServerRoles.sql o roles.txt w 132

This creates a report roles.txt that outlines which roles have access to each map, this will be utilised once the maps have been reconfigured for Dekho v3.0.

With the two reports output from your existing Dekho configuration database, it can now be upgraded to version 3. This process will remove all maps from the database, allowing their reconfiguration for version 3.0.

Depending on your current version of Dekho 2.x, several upgrade scripts may need to be run before the final 3.0 upgrade script. The 3.0 upgrade scripts must be run on the most up to date version of Dekho 2.x, which is 2.2.6, so if you are currently on 2.2.4 for example, three scripts would be required for example




Each of the above scripts should be edited and the first command altered to reflect your database name. The scripts can then be run through SQL Server Management Studio or through the command line as follows:

sqlcmd i sqlserverupgrade2.2.6to3.0.sql

Once all scripts have been run, your database has been prepared for Dekho v3.0.

The Dekho Administration Guide for v3.0 contains details on how to recreate your Dekho 2.x based maps in Dekho 3.

In Dekho 2.x Map Queries uniquely identified map layers by the name of the feature class in which their data was stored, in Dekho 3.x this unique identifier is the fully qualified layer name itself, i.e:




Oracle Upgrade