When running the Foundation DBUtils application, you can apply command line switches. Command line switches can be applied to specify database connection information, specify an alternative JSON configuration file, or view help information.
Any options specified by applying command line switches override the corresponding option specifications in any default or custom JSON configuration files.
The following command line switches can be applied when using the upgrade command:
Switch |
Description |
---|---|
--datasourcename |
A unique name, defined by the user, to identify the connection string used to connect to the database. Note:
This identifying name may be different from the name of the actual database. |
--connectionstring |
The connection string used to connect to the database. |
--provider |
The data provider type used for the database. Only SQL Server and Oracle data providers can be used to connect to the OnBase database. Use one of the following:
|
--configoverride |
Specifies the full path to a custom JSON configuration file. |
--help |
Displays help information. |
For example, the following upgrade command updates a database, and the command line switches provide the connection information for the database. In this example, an interactive challenge code is used to validate the upgrade:
foundationdbutils.exe upgrade --datasourcename "DataSourceName" --connectionstring "Data Source=Serv001\instance;database=TestDB;User Id=username;Password=password" --provider "System.Data.SqlClient" interactive