Tick all three options under Objects to Export:

• Dump Stored Procedures and Functions
• Dump Events
• Dump Triggers

As part of the backup process with regards to Curator services, it is recommended to make a backup of the Solr folder structure in the event of needing to roll back. 

Note: This is a manual step and should only be attempted when the Curator Server Service has been stopped, making a backup copy while it is running may lead to corruption of the copied database.

By default, the Solr folder to copy is found here: C:\Program Files\IPV\Curator\Server\Solr\server\

Confirm Successful Export

Copy the entire Plugins folder to a safe location.

Browse to:

%ROOT_TO_INETPUB%\inetpub\wwwroot\CuratorClipSelect  

dotNET 4.7 is required for certain Curator Services and Applications. If not already installed by default on the system, Windows 2016 Servers and earlier will not have it by default - download it and install it from Microsoft's website.

The Microsoft Visual C++ Runtime libraries are required. Download and run the installers using the links below and accept default settings.

Visual Studio 2013 C++ Redistributable can be downloaded from Microsoft's Website.

Visual Studio 2015-2019 C++ Redistributable can be downloaded from Microsoft's Website.

Only install Apple's ProRes codecs if the system needs to support ProRes material - this is an optional component.

The ProRes codecs are included as "QuickTime Essentials" within the QuickTime installer from Apple's Website.

Click Install IIS to look at a detailed install guide if required.

IIS (Internet Information Services) is a webserver which can be selected as a Server Role in the OS Server Manager.

Add all dot net options to the default features and select all the Application Development options under Role Services when prompted.

WebDeploy is an IIS tool that enables Curator Web applications to be easily imported into the webserver.

Download the 64-bit installer from Microsoft's official website.

Note: You may already have WebDeploy installed as part of your previous install.
Please ensure you have upgraded to version 3.6 Refer to the guide here on how to upgrade if necessary.

URL Rewrite is a module for IIS

Download an installer from Microsoft's Website.

Runtime version .Net Core 3.1 and .Net Core 5.0 (new) are required support for Curator Gateway. Download the installers from Microsoft's Website.  

Java provides features to the Curator Server Service.

Click here to view the recommended Java options.

Some IPV Services require the MySQL relational database.

Download the installer from MySQL's Official Website.

The Analytics Service requires Neo4j as its database.

Download the Community version zip file from Neo4j's website.

- During the upgrade to this release, you MUST delete the Solr Core located in [installation path]\Curator\Server\Solr\server\solr\. From here, delete the  curator_2_4 folder. The correct Core will be generated by starting the service.

1. Ensure that curatordb has been backed up. If there is no backup, then manually create one before upgrading Curator Server.
2. In Workbench - close the Database Connection (if already open)
3. Under the Home tab, go to the edit menu > preferences and access the SQL Editor on the left.
4. Increase the timeout. To do this, under MySQL Session on the right, update the 3x (in seconds) values dramatically, by a factor of 10 or even 100 (at least temporarily).
5. On the right scroll down and under Other UNTICK Safe Updates
6. Click OK for these settings to take effect.
7. Open the Database Connection.
8. Double click and expand the Curator Server Database on the left.
9. From the File menu in the database tab select Run SQL Script and select the Sql\Upgrade\UpgradeV2-7ToV3-0[manual].sql script provided in Curator Server installation path, ensure the correct database is selected and press Run.

Enter MySQL Details

If the MySQL Dump Fullpath field is not already configured as shown in the screenshots, find the MySQL installation directory and the mysqldump.exe file under the Bin folder.

After confirming valid details, click Next:

Note: Do not change the Solr core configuration. Solr is installed alongside Curator Server.

Enter an SSL certificate thumbprint for setting up HTTPS connectivity.

Change the Curator Gateway host with the IIS hosts FQDN/IP.

Replace:

https://localhost/CuratorGateway 

With:

https://IIS_HOST/CuratorGateway 

To do this, load the Services list and start IPV Curator Server:

• .NET 4.7.2
• WebDeploy 3.6
• MySQL

Accept Licence Agreement

Set Service Logon Account

Change the Curator Gateway host with the IIS host FQDN/IP.

Replace:

https://localhost/CuratorGateway 

With:

https://IIS_HOST/CuratorGateway

The Client Id for IPV Device Director Service and Client Secret for IPV Device Director Service should be entered here to allow Device Director to use Curator Gateway authentication.

To find these, go to the Curator Gateway Clients tab and select Device Director Service from the list, then copy the Id and Secret values using the copy to clipboard icon to the right of each value.

If the Secret value is not yet present, this will need to be set for this client.

The client secret can be set by selecting the edit icon to the right of the Device Director Service client and saving without making any changes.

This will generate the Secret where this is not yet present, which you will then be able to copy.

Choose Installation Destination

•  .NET 4.7.2
• WebDeploy 3.6
• MySQL
• GhostScript

Accept Licence Agreement

Set Service Logon Account

Enter MySQL Details

Change the Curator Gateway host with the IIS hosts FQDN/IP.

Replace:

https://localhost/CuratorGateway 

With:

https://IIS_HOST/CuratorGateway 

Choose Installation Destination

•  .NET 4.7.2
• WebDeploy 3.6
• MySQL
• GhostScript

• Licence Manager

•  .NET 4.7.2

Remove and Import the following applications:

• Curator Clip Link
• Curator Clip Select
• Curator Gateway
• Curator Logger
• Device Director Website
• Process Engine Monitor
• XChange Manager Website

Import the following application: 

• Curator File Service (Click here for a guide)

 Use WebDeploy to import the new version.

For a reminder on how to import applications in IIS, click here.

Additional web.config modification is needed in systems running Curator 3.4 or newer with CSA version 1.6 where the TSL1 has been removed as is possible from Curator 3.4 onwards. This will be automatically set from CSA 2.0 (scheduled for Curator 3.6)

The CSA 1.6 web.config needs to be modified where TSL1 is not available. You will need to add the following two lines to the CSA web.config file:

<add key="AppContext.SetSwitch:Switch.System.Net.DontEnableSchUseStrongCrypto" value="false" />
<add key="AppContext.SetSwitch:Switch.System.Net.DontEnableSystemDefaultTlsVersions" value="false" />

For Curator Connect

Open Curator System Administrator navigating to the configuration tab

Note: If upgrading from any previous release of this product on a PC, please uninstall the previous release and check that the following folder locations are empty before attempting to install this version:
- C:\Program Files\Adobe\Common\Plug-ins\7.0\MediaCore
- C:\Program Files\IPV\IPV Curator For Adobe\ 
Also delete: C:\Users[user]\AppData\Roaming\IPV\Premiere Extensions\IPVExtension.config.json
This will ensure correct installation, especially of the correct importer and exporter components (which cannot be directly visually verified)

Start Curator Server

Start Process Engine Service

Browse to:

http://localhost/ProcessEngineMonitor/Modules 

Browse to the Process Engine install directory and select the corresponding version package ( x.y.z.a and in the image below replaced by the version of Workflows-Core  provided with your installation of the Process Engine e.g. 3.3.0.7)

%INSTALL_PATH%\Program Files\IPV\Process Engine Service\BundledModules\Workflows-Core-x.y.z.a.zip

Choose the appropriate Adobe workflow zip file, then click Open:

• In Curator 3.5, by default, image Essence is not generated during the ingest. If Curator Clip Select is required you should alter StoreEssenceBlob to True in IMAGE-PROXY MediaStore.

Execute the steps on this page for the two folders listed below. The examples are on CuratorGateway but must also be applied to ProgramData\IPV:

• \inetpub\wwwroot\CuratorGateway
• \ProgramData\IPV

Under the root Windows install directory, find the ProgramData folder:

This folder is a hidden item. To show this folder, ensure hidden items are visible (these can be made visible from the View tab):

Click Locations. If prompted to log in, provide valid credentials or credentials to the system, and select the host machine:In the object names field, enter IIS_IUSRS and click Check Names:When finished, click OK.

In Name, enter:

Access-Control-Allow-Headers

In Value, enter:

Range,Cache-Control

In Name, enter:
Access-Control-Allow-Origin

In Value, enter the server name hosting the IIS.

Alternatively, "*" can be used for all hosts but poses security risks:
http://IIS_HOST
Click OK to confirm. 

Change the maxRequestEntityAllowed value (if not already set) to: 4294967295

Change the uploadReadAheadSize value from: 49152

To: 2147483647

Expand requestLimits and change the maxAllowedContentLength value from: 30000

To: 4294967295 

Browse to Curator Gateway

Additional web.config modification is needed in systems running Curator 3.4 or newer with CSA version 1.6 where the TSL1 has been removed as is possible from Curator 3.4 onwards. This will be automatically set from CSA 2.0 (scheduled for Curator 3.6)

The CSA 1.6 web.config needs to be modified where TSL1 is not available. You will need to add the following two lines to the CSA web.config file:

<add key="AppContext.SetSwitch:Switch.System.Net.DontEnableSchUseStrongCrypto" value="false" />

<add key="AppContext.SetSwitch:Switch.System.Net.DontEnableSystemDefaultTlsVersions" value="false" />

Replace

"Thumbnail VTT Location" key value

Search for the ThumbnailVttLocation key and replace the value with the fully qualified domain name for the webserver and the virtual directory configured during the ingest functionality deployment.

Replace:

<add key="ThumbnailVttLocation" value="https://WEBSERVER/Proxies/WebProxy/{proxy-path}/{name}/{name}_thumbnail.vtt" />

With:

<add key="ThumbnailVttLocation" value="https://IIS_HOST/Proxies/WebProxy/{proxy-path}/{name}/{name}_thumbnail.vtt" />

Search for:  

<OpenInLogger url="https://localhost/CuratorLogger/Log?assetId={id}" enabled="true" />

Setting (enabled="false") will hide the option in the Clip Link menu.

If Logging is required, replace localhost with the webserver hosting the logger application and set enabled="true":

<OpenInLogger url="https://IIS_HOST/CuratorLogger/Log?assetId={id}" enabled="true" />

Find the following keys and replace the value with the required metadata views:

<add key="SearchFilterViewName" value="SearchLevelView" />

<pinnedSearches>
<searches>
<clear />
<add imageFileName="Example.svg" tooltip="Example Search" searchParameters="?assetFilter=159&amp;s=ingestdate&amp;d=descending" />

Find the AddToCollection tag and change the values as required, adding missing metadata names within the Path Metadata tag if necessary.

<AddToCollection>
<MetadataView name="Collections" />
<BaseLocation name="Library" /
<PathMetadata>
<Metadata name="CollectionType" />
<Metadata name="CollectionDestination" />
<Metadata name="Priority" />
</PathMetadata>
</AddToCollection>

If you are upgrading a site where non-default tabs or views are configured, please note that as of Clip Link 3.3, the xml tags have changed from <View name=... /> to <Tab name=... /> (see the current form below).

NOTE: Do not copy over old lines of configuration file.

If you wish to configure additional or different metadata views in tabs, find the <AssetInfo> tag in web.config and configure this providing your view of choice, the name of the tab and whether to display metadata from the asset or its parent in this tab. With parent="true" for clipmarks this will be media metadata and nothing will display for popped up media, audio or images.

<AssetInfo>
<Tabs>
<Tab name="ViewName1" display="Displayed Name of Tab1" parent="false"/>
<Tab name="ViewName2" display="Displayed Name of Tab2" parent="false"/>
</Tabs>
</AssetInfo>

Replace any missing images in:

%INSTALL_PATH%\inetpub\wwwroot\CuratorClipLink\Content\Images\PinnedSearches\

Replace any missing custom plugins in the plugins top-level folder:

%INSTALL_PATH%\inetpub\wwwroot\CuratorClipLink\Plugins\

On the IIS server, open IIS manager and browse to the Curator Logger directory by right-clicking and selecting the Explore option:

Replace

"Video Server

Address" key value

Set the value for the VideoServerAddress key with the fully qualified domain name for the IIS host.

Replace: 

<add key="VideoServerAddress" value="https://WEBSERVER" /> 

With:

<add key="VideoServerAddress" value="https://IIS_HOST" />

Replace

"Thumbnail Vtt Location" key value

Search for the ThumbnailVttLocation key and replace the value with the fully qualified domain name for the webserver and the virtual directory configured during the ingest functionality deployment.

Replace:

<add key="ThumbnailVttLocation" value="https://WEBSERVER/Proxies/WebProxy/{proxy-path}/{name}/{name}_thumbnail.vtt" />

With:

<add key="ThumbnailVttLocation" value="https://IIS_HOST/Proxies/WebProxy/{proxy-path}/{name}/{name}_thumbnail.vtt" />

Uninstall Apache

cd C:\Apache24\bin

.\httpd.exe -k uninstall

Remove Apache files

After Apache has been uninstalled, close the open Command Prompt window. It is now safe to delete the Apache24 folder.

Open Programs and Features

Open Control Panel and go to Programs and Features:

Uninstall ActivePerl

Right-click on ActivePerl and click Uninstall. To the prompt, click Yes.