Install Guide

GUID-E660BA4F-137A-4D32-82B1-6159CC886736

Manual installation of WDM database using scripts

This section contains database scripts supported by Wyse Device Manager (WDM) and related functionality details.

CONCEPT-13-9B7B8096

Requirements

Existing WDM database support

WDM installation supports SQL Server 2008. The database contains all the SQL server objects such as tables, views, stored

procedures, and so on. The WDM installer stores the database to the respective folder (default is: C:\Program Files (x86)\Wyse

\WDM\Database

) and attaches the same to server machine where WDM needs to be install.

Then the installer updates the server details, user details, Software Repository conguration details, and so on to the server machine.

CONCEPT-14-9B7BAFBB

Proposed way of installing WDM database

Provided scripts are used to install WDM database version 5.7.

Prerequisites—Before executing the scripts, the database path folder must be created and rewall must be disabled in the database

server.

NOTE: The following scripts must be executed in the same order as they are mentioned. If not, you have to delete the

database and repeat the entire process again.

GUID-2FDC0585-3B1E-47CF-B454-1120E3000336

Script les

The following database script les will be used to install database of WDM 5.7:

• CreateDatabase.sql

• Schema&User.sql

• Tables.sql

• Userdenedtables.sql

• Views.sql

• Stored_Procedures.sql

• Default_Table_Data.sql

• CustomizeScript.sql

CreateDatabase.sql

To create the database manually, execute the following script: