Configuring a Microsoft SQL Server Database Connection From the Command Line

You can configure the database connection by opening a command window as an Administrator and running dbconfig.exe.

The following are default location for dbconfig.exe:

<local drive>\Program Files\Oracle\Primavera P6\P6 Professional (with the 32-bit version of P6 Professional on a 32-bit operating system)
<local drive>\Program Files (x86)\Oracle\Primavera P6\P6 Professional (with the 32-bit version of P6 Professional on a 64-bit operating system)
<local drive>\Program Files\Oracle\Primavera P6\P6 Professional (with the 64-bit version of P6 Professional on a 64-bit operating system)

Use the following command line parameters with dbconfig.exe:

Parameter	Description
`-a<Alias Name>`	Where `<Alias Name>` is any valid Alias Name value.
`-s<Driver type>`	The following are valid values for <Driver type>: Oracle, MSSQL, or PrCSdrv Driver Type values are case-sensitive.
`-d<Database Name>`	Specify a valid SqlServer database name, such as PMDB. For a Compression Server, specify `<CompressionServerDatabase Name><@HostName>` or `<CompressionServerDatabase Name><@IPaddress><:Port[http]>`.
`-h<Host Name>`	Specify a valid SQL Server Database `<ServerName>` or `<IP Address, PORT>`.
`-u<Database pubuser name>`	Where `<Database pubuser name>` is the valid pubuser name.
`-w<Database pubuser's password>`	Where `<Database pubuser's password>` is the valid pubuser's password.
`-b<Public Group ID>`	Optional. A valid value is any integer. The default is 1.

Notes:

The parameters can be positioned in any order.
Ensure there is no space after each parameter keyword and its value, and ensure there is one space between each parameter. For example, this is correct: -amySqlServerAlias -sMSSQL.
The following example is incorrect because there is a space between the parameter keyword and its value: -a mySqlServerAlias -s MSSQL.
The following example is incorrect because there is no space between parameters: -amySqlServerAlias-sMSSQL.

Examples

The following example creates or modifies the sqlserver alias (mySqlServerAlias):
dbconfig -amySqlServerAlias -h10.140.179.3,1433 -upubuser -wpubuser -sMSSQL -dpmdb
The following example creates or modifies the compression server alias (myCSAlias):
dbconfig -amyCSAlias -upubuser -wpubuser -sPrCSdrv -dMyCompressionServer@10.140.162.174:5555[http]

where:
- MyCompressionServer is the value for the CompressionServerDatabase Name part of the -d<Database Name> parameter.
- 10.140.162.174 is the value for the IPaddress part of the -d<Database Name> parameter.
- 5555 is the value for the Port part of the -d<Database Name> parameter.

Last Published Tuesday, August 02, 2016