Use the Hyland Healthcare Configuration Provider Admin tool to check an existing database for pending schema migrations.
To check for schema updates:
- Open a Command Prompt using the Run as administrator option.
- In the Command Prompt, navigate to the directory where Hyland.Healthcare.Config.Provider.Admin.exe is located.
-
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.
-
-
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.
-