Running the Foundation DBUtils Application - System Administration - On-Premises - English - Foundation 22.1 - OnBase - Essential - Premier - Standard - external - Standard - Essential

Running the Foundation DBUtils Application - System Administration - On-Premises - English - Foundation 22.1 - OnBase - Essential - Premier - Standard - external - Standard - Essential - Premier

On-Premises System Administration

Platform

OnBase

Product

System Administration - On-Premises

Release

Foundation 22.1

License

Standard

Essential

Premier

The Foundation DBUtils application can be run from the command line or using the user interface.

To re-upgrade a database using the Foundation DBUtils User Interface:

Launch FoundationDBUtilsUI.exe.
Navigate to the ReUpgrade tab.
Select the appropriate data source from the Data Source drop down list.
To have detailed messaging and SQL statements logged to the window during database upgrade process, select Verbose.
Click ReUpgrade.

When the Foundation DBUtils application is run from the command line, you must use the reupgrade command to re-upgrade your database.

When running the Foundation DBUtils application from the command line, 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.

Note:

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 reupgrade 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: For a SQL Server database: "System.Data.SqlClient" For an Oracle database: "Oracle.ManagedDataAccess.Client"
--configoverride	Specifies the full path to a custom JSON configuration file.
--help	Displays help information.

For example, the following reupgrade command re-updates a database, and the command line switches provide the connection information for the database:

foundationdbutils.exe reupgrade --datasourcename "DataSourceName" --connectionstring "Data Source=Serv001\instance;database=TestDB; User Id=username;Password=password" --provider "System.Data.SqlClient"