Creating the Solution Schema - Hyland Clinician Window - 23.1 - 23.1 - Other - external

Hyland Clinician Window

Hyland Clinician Window

Use the Hyland Healthcare Configuration Provider Admin tool to add the solution configuration schema to an existing database.

  • If the solution schema exists in the database, the tool upgrades the database to the latest migration. The operation fails if the schema is already up-to-date.

  • If the solution schema does not exist in the database, the tool creates the schema and populates the tables.

To add the solution schema to a database:

  1. Open a Command Prompt using the Run as administrator option.
  2. In the Command Prompt, navigate to the directory where Hyland.Healthcare.Config.Provider.Admin.exe is located.
  3. Run the executable in migrate mode using the appropriate arguments to connect to your database.
    • For a SQL Server database:

      Hyland.Healthcare.Config.Provider.Admin.exe migrate -d "Data Source={ServerInstance};Initial Catalog={DatabaseName};User Id={Username};Password={Password};" -s "solution" -p "mssql"

    • For an Oracle database:

      Hyland.Healthcare.Config.Provider.Admin.exe migrate -d "Data Source={DatabaseHostname};Service Name={DatabaseName};User Id={Username};Password={Password};" -s "solution" -p "oracle"

    The tool indicates whether the operation succeeded or failed. If the operation succeeded, then the schema was added or updated successfully. If the operation failed, then no changes were made to the database.