Installing NerveCenter - Doing Silent and Remote Installations on Windows - Creating your Database from the Command Line -
Installing NerveCenter Remotely      Configuring the Database Remotely

Creating your Database from the Command Line

Instead of using the wizard, you can create or modify your database from the command line.

Whether you are doing a silent or remote creation of your database, you must edit the database configuration file, InstallDB.idb. This file lets you specify the information necessary for creating a database.

 
  To edit InstallDB.idb for an SQL Server database:

You need to provide all required information about the destination server and your options to InstallDB.

Revise the contents of InstallDB.idb, located in the installation/DB directory, as follows, substituting the names for your server, user ID, database, and so on. For a review of the options, see Creating a SQL Server Database on page 36.


   SQL Server Name: ServerName
   SQL User Id: sa
   SQL Password:
   Database Name: NerveCenterDB
   Data Device Name: NC_Data
   Data Device File Name: C:\SQL\Data\NC_Data.dat
   Data Device Size in MB: 10
   Log Device Name: NC_Log
   Log Device File Name: C:\SQL\Data\NC_Log.dat
   Log Device Size in MB: 10
   Data Source Name: NerveCenter_DataSource_Name
   Path to SQL Files: Path
   SQL Script File Name: NCScript.sql
   Database File Name: NCExport.asc

 
  To edit InstallDB.idb for an Access database:

Revise the contents of InstallDB.idb, located in the installation\DB directory, as follows:

Delete all the lines in the InstallDB.idb file and replace with the following three lines:


   Access File Name: Path\NCAccess.mdb
   Data Source Name: ODBC_data_source
   Database File Name: Path\NCExport.ASC

Once you edit the InstallDB.idb file, you can run InstallDB.

 
  To create your database from the command line:

  1. From a DOS prompt, cd to the installation\nervecenter\bin directory.
  2. Type the InstallDB command with the appropriate parameters, then press Enter.

The syntax is:


   InstallDB -F IDBfile -O {f|l|c|r} -D {s|a} [-M {v|s}] [-H]
Parameter Description

   -F IDBfile

The path and file name for the IDB file.

This parameter is required.


   -O {f | l | c | r}

Specifies the operation code. The choices are:


   -D {s | a}

Specifies the database type. The choices are:

  • s -- SQL
  • a -- Access

    This parameter is required.


       The SQL script can only run against a SQL database, not an Access database. If the operation parameter is r (run SQL script), then you must specify s (SQL) as the database type.

   [-M {v | s}]

Specifies the mode of operation: v is verbose, and s is silent.

This parameter is optional; if nothing is specified, it defaults to s (silent).


   [-H]

Displays usage help in a dialog box. (You can also enter simply installdb.)

For example:


   InstallDB -F c:\temp\InstallDB.idb -M v -O f -D s

Installing NerveCenter Remotely Configuring the Database Remotely
29 July 2003