Setup MS SQL Server

1. Backup DS_WEB database.
2. Execute the attached DS_Web_update.sql to update data schema for DS_WEB database.

Please note that this SQL script includes cumulative updates since v2.5. Run the required scripts only and skip the scripts for the older versions.

Setup WEB Server

1. Backup the original dsweb folder from C:\inetpub\wwwroot\.
2. Replace the original dsweb folder in C:\inetpub\wwwroot\ with attached NEW dsweb folder.
3. Go to IIS, and ensure that the DSWeb application uses .Net Framework 4.
4. Edit the Connection String.

DSWeb version 2.8 and higher has two different ways to set up connection string.

DSWeb v2.7 and earlier versions use a registry entry. If you wish to continue to use the registry key for the connection string, use the following web.config file.

<configuration>

  …

 <appSettings>

        <!--

        CnnStrLocation=ConfigFile:      It looks into Web.Config file for connection string;

                      =Registry         It looks into Registry file for connection string;

This is the default value if the 'CnnStrLocation' key is missing.

        DB_RegCnnStr="CnnStrDev" This is the registry location for connection string;

        CnnStr=""   Production environment connection string;

        CnnStrDev=""  Developement enviroment connection string;

        -->

    <add key="CnnStrLocation" value="Registry" />

    <add key="DB_Name" value="DS_WEB" />

    <add key="DB_RegCnnStr" value="CnnStr" />

…

  </appSettings>

  …

</configuration>

To move the connection string into a web.config file make the changes as outlined below.

<configuration>

  …

 <appSettings>

        <!--

        CnnStrLocation=ConfigFile:      It looks into Web.Config file for connection string;

                      =Registry         It looks into Registry file for connection string;

This is the default value if the 'CnnStrLocation' key is missing.

        DB_RegCnnStr="CnnStrDev" This is the registry location for connection string;

        CnnStr=""   Production environment connection string;

        CnnStrDev=""  Developement enviroment connection string;

        -->

    <add key="CnnStrLocation" value="ConfigFile" />

    <add key="DB_Name" value="DS_WEB" />

…

  </appSettings>

  <connectionStrings>

    <!--              CnnStr=""   Production environment connection string;

CnnStrDev=""  Developement enviroment connection string;    -->

<add name="CnnStr" connectionString="Data Source=SERVERNAME;Initial Catalog=DS_WEB;Persist Security Info=True;User ID=dswebuser; Password=PASSWORD" />

  </connectionStrings>

…

</configuration>