Install Guide

Manual installation of WDM database using

scripts

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

Topics:

• Requirements

• Proposed way of installing WDM database

• Script les

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.

Proposed way of installing WDM database

The scripts are used to install WDM database version 5.7.3.

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.

Script les

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

• 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:

Manual installation of WDM database using scripts 105