beautypg.com

Running the batch files – Grass Valley iTX Delivery Manager v.2.6 User Manual

Page 47

background image

41

Delivery Manager

Configuration and Setup Guide

There are five parameters you need to set:

[sqlserver]

Enter the name of the SQL server running the Colossus/iTX 1.4
database you want to install to

[coredatabasename]

Enter the name of the Colossus/iTX 1.4 database on that server

[installDeleteTrigger]

Set to

true

or

false

.

[sqladminuser]

Enter the SQL admin username.
Not required if you are using a trusted connection.

[sqlpassword]

Enter the SQL admin usernames password.
Not required if you are using a trusted connection.

When typing the required names/strings for these parameters, separate each one with a single
space, for example:

iTXDBSVR OMNIBUS false ITXADMIN letsgothere

Note:

There are two accompanying README files that detail these

parameters, one for each type of database.

IMPORTANT

These batch files are to be run from the machine on which Delivery
Manager is installed. There is no need to copy them locally to the
Colossus/iTX 1.4 database server and run them from there.

Running the batch files

To run the batch files that will execute the required SQL scripts:

1 Click Start>Accessories>Command Prompt. An MS-DOS Command Prompt window

appears.

2 Type the exact path and file name of the batch file you wish to execute, along with the

required parameters. Each parameter you enter needs to be separated by a single
space. e.g.:

C:\Program Files\iTX 2.0\Services\Delivery Manager
Service\Drivers\Core DB Installer\InstallCoreDbObjects.bat [sqlserver]
[coredatabasename] [sqladminuser] [sqlpassword]

3 Press Enter. The batch file will run.

4 When all of the table objects have been added, the batch file will return the message

Installation complete

.

This manual is related to the following products: