Creating new a Discovery Center Database using command line

Purpose & Scope

There may be a time where you wish to create a new blank Discovery Center database. This can be achieved by using a command-line tool included with the product, Discovery Center must be installed on a system as the application is contained within the Program files directory.

Procedure

1. Open a command line as an administrator
2. Change directory to the folder where Discovery Center is installed and the database directory (default location C:\Program Files (x86)\Active Navigation\Discovery Center\Database)
3. To see the required syntax run the CreateANDatabase.exe application on its own 
4. To create a new blank database the command line would look like the following
   
   

   CreateANDatabase.exe localhost ActiveNav4 'C:\Program Files (x86)\Active Navigation\Discovery Center\Database\Database Definition' CORP\sysadmin Passw0rd1! /install

Once this has been run and completed, a new database will be created. You should be able to check this in SQL management studio.