Cinchy Upgrade Utility
This page details information on the Cinchy Upgrade Utility.
Last updated
This page details information on the Cinchy Upgrade Utility.
Last updated
The Cinchy Upgrade Utility was first introduced in v5.2 to ease a mandatory INT to BigInt upgrade. This tool has continued to be used in subsequent releases as an easy way to deploy necessary changes to your Cinchy platform.
Upgrades will also be specified on the applicable Upgrade Guide page for each release.
Depending on your upgrade path, certain upgrades must be performed in sequential and/or specific order. This will be clearly marked in the "Overview and Considerations" section.
For example: To go from v5.1 to v5.5, you would first have to run the 5.2 upgrade utility and deploy the release. Once validated, you would then run the 5.5 upgrade and deploy that version.
Not all new releases will have changes that require the utility to be run. Review the table in section 4 for the full list.
You will need to run this process as a user with admin/dbowner privileges to your database.
You will need to have .NET Core 6.0.x installed on the machine that you will run the utility on.
Retrieve the Upgrade Utility from the Cinchy Releases table.
Release | Upgrade | Kubernetes Upgrade | IIS Upgrade |
---|---|---|---|
We recommend you follow this process during off-peak hours.
Turn off your Cinchy platform. (Note: This step is only required for the 5.2 upgrade)
In a Kubernetes deployment, you can do so via ArgoCD.
In an IIS Deployment:
Open your Windows Services Panel.
Select IIS Admin Service.
Stop the service.
Right-click IIS Admin Service and select Properties.
Change 'Start Up Type' to 'Disabled'.
Create a backup snapshot of your platform.
In a Kubernetes deployment on AWS, you can follow the documentation here.
In a Kubernetes deployment on Azure, you can follow the documentation here.
In an IIS Deployment, you can follow the documentation here.
Retrieve the Upgrade Utility from the Cinchy Releases table if you haven't already.
Run the following command through a command window as an admin/dbowner, using the table below as a guide.
You will see the below progress bar as your upgrade completes (Image 1). Once it's done, you will see a VALIDATION PASSED check.
Tip: Click on the image below to enlarge it.
If there are any errors during execution or your validation fails, we suggest that you restore your database from the backup and contact Cinchy support.
Note: You must deploy whichever version of the platform you ran the upgrade utility for.
If it was turned off in step 1, turn your Cinchy platform back on.
In a Kubernetes deployment, you can do so via Argo CD
In an IIS deployment:
Open your Windows Services Panel.
Select IIS Admin Service.
Start the service.
Right-click IIS Admin Service and select Properties.
Change 'Start Up Type' to 'Enabled'.
Value | Description |
---|---|
5.2
Upgrade Guide
5.5
Upgrade Guide
-d
Mandatory. Database type. This can be either TSQL or PGSQL.
-s
Mandatory. Connection String. You must provide the unencrypted connection string for your database.
-v
Mandatory. This specifies the upgrade version that you wish to deploy. Ex: specifying "5.2" will run the 5.2 upgrade.
-c
Optional and not recommended to be used on your first run of the utility. This "clean up" value will delete any extra metadata the application created on the database