Checking for Schema Updates - Hyland Clinician Window - 23.1 - 23.1 - Other - external

Hyland Clinician Window

Hyland Clinician Window

Use the Hyland Healthcare Configuration Provider Admin tool to check an existing database for pending schema migrations.

To check for schema updates:

  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 dbversion mode using the appropriate arguments to connect to your database.
    • For a SQL Server database:

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

    • For an Oracle database:

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

    The Hyland Healthcare Configuration Provider Admin tool displays the applied schema migrations and any pending migrations.

  4. Depending on the result, do one of the following:
    • If there is a pending migration, perform the migration as described under Updating the Schema.

    • If there are no pending migrations, then the database schema is up-to-date.