The Configure Database utility allows you to perform database configuration operations. You can perform the operations either by executing the ConfigureDatabase.exe or by using the Runtime Administration Tool. Following are the operations:
Create Database: Databases can be created and configured by executing the ConfigureDatabase.exe.
Database Server Registration – Once you select a server machine, you need to add a database server registration for each of the runtime servers to which you want to add databases. You can add a database server registration by executing the ConfigureDatabase.exe.
Attach an existing Database – To add an existing database, you must attach it to the new Windows Runtime environment by executing the ConfigureDatabase.exe.
Detach a Database – Detaching a database involves the removal of database from the runtime environment but does not delete the database or the data it contains. You can detach the database by executing the ConfigureDatabase.exe.
Delete a Database – Deleting a database involves the complete removal of the database from the server. You can only delete a database if it does not contain any applications. You can delete the database by executing the ConfigureDatabase.exe.
Removing a Database Server Registration – You can remove the database server registration by executing the ConfigureDatabase.exe.
This utility is automatically installed with Agile Business Suite Runtime and is located in the AB Suite 7.0 installation directory. You can invoke the utility from the command line to configure database.
Note: By default, a local administrator can use ConfigureDatabase.exe.
To run ConfigureDatabase.exe from a command line:
Point to the bottom-left corner of the screen to enable the Start icon, right-click Start, and then click Run.
Type cmd in the Run dialog box and press Enter to open a Command Prompt.
In the command prompt, change the working directory to the /bin64 folder of the AB Suite 7.0 installation directory.
cd C:\Program Files\Unisys\AB Suite 7.0\Bin64Type "ConfigureDatabase.exe /?". This displays the complete usage of the utility.
The syntax of ConfigureDatabase for creating a database is:
ConfigureDatabase /C /DBN <database name> /ALS <database server alias> [/?]
Parameters
| Argument | Description |
|---|---|
| /C | Creates a new database on the database server. |
| /DBN | Specifies the name of the database that will be created. Note: This argument is mandatory. |
| /ALS | Specifies the database server registration under which this database is created. Notes:
|
| /? | Displays the command line syntax and arguments of the utility. If specified, a usage message appears and the utility exits. |
The syntax of ConfigureDatabase for deleting a database is
ConfigureDatabase /D /DBN <database name> /ALS <database server alias> [/?]
Parameters
| Argument | Description |
|---|---|
| /D | Deletes the specified database from the database server. |
| /DBN | Specifies the name of the database that will be deleted. Note: This argument is mandatory. |
| /ALS | Specifies the database server registration under which the database that will be deleted exists. Notes:
|
| /? | Displays the command line syntax and arguments of the utility. If specified, a usage message appears and the utility exits. |
The syntax of ConfigureDatabase for attaching a database is
ConfigureDatabase /AT /DBN <database name> /ALS <database server registration> [/?]
Parameters
| Argument | Description |
|---|---|
| /AT | Attaches the specified database to the runtime environment. |
| /DBN | Specifies the name of the database that will be attached. Note: This argument is mandatory. |
| /ALS | Specifies the database server registration under which the database will be attached. Note: This argument is mandatory. |
| /? | Displays the command line syntax and arguments of the utility. If specified, a usage message appears and the utility exits. |
The syntax of ConfigureDatabase for detaching a database is
ConfigureDatabase /DT /DBN <database name> /ALS <database server registration> [/?]
Parameters
| Argument | Description |
|---|---|
| /DT | Detaches the specified database to the runtime environment. |
| /DBN | Specifies the name of the database that will be detached. Note: This argument is mandatory. |
| /ALS | Specifies the database server registration under which the database will be detached. Note: This argument is mandatory. |
| /? | Displays the command line syntax and arguments of the utility. If specified, a usage message appears and the utility exits. |
The syntax of ConfigureDatabase for creating a database server registration is
ConfigureDatabase /REG /ALS <database server alias> [/SQL <sql instance name>] [/H <database server machine>]
Parameters
| Argument | Description |
|---|---|
| /REG | Creates a database server registration for the runtime environment. |
| /ALS
| Specifies the database server registration that will be created. Note: This argument is mandatory. |
| /SQL | Specifies the SQL instance name which the database server alias represents. If this parameter is not specified, the default instance is assumed. |
| /H | Specifies the name of the database server. If this parameter is not specified, localhost is assumed. |
| /? | Displays the command line syntax and arguments of the utility. If specified, a usage message appears and the utility exits. |
The syntax of ConfigureDatabase for removing a database server registration is
ConfigureDatabase /URG /ALS <database server alias>
Parameters
| Argument | Description |
|---|---|
| /URG | Removes a database server registration from the runtime environment. |
| /ALS | Specifies the database server registration that will be removed. Note: This argument is mandatory. |
| /? | Displays the command line syntax and arguments of the utility. If specified, a usage message appears and the utility exits. |