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 and is required for services with Neo4j databases. Metadata Central Teragator has a new Java 11 version requirement.

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 Neo4J is required in specific versions by these services:

- for Analytics Service stays the same: Neo4j 3.5
- for Metadata Central Teragator 2.0.4 is new: Neo4J 4.3

See Neo4j for installation and upgrade details. 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 click 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 

If the version returned by the previous step is older than 2.7.0.0 (that is, you are upgrading from before Curator 3.3 (Curator Server 3.6)), you must first go to the next step in order to upgrade your scripts, and then return here once you have upgraded to version 2.7.0.0 or later to run the fixing Helper script:

Navigate to this folder: [Curator Server Installation Path]\Sql\Helpers\V2-7ToV3-0\.

From here, select FoldersWithBrokenFullPaths.sql and FixBrokenFullPaths.sql.

Run SelectFoldersWithBrokenFullPaths.sql to check for broken folder full_paths. This will list sets of folders where the full_path might have been corrupted in the past (this may happen when moving large folders).

An example output is shown below:

If any folders are listed, run FixBrokenFullPaths.sql. The script should complete automatically.

Following this, re-run SelectFoldersWithBrokenFullPaths.sql. This might still give an output, in which case you will need to run the FixBrokenFullPaths.sql again and verify that there is nothing listed for the SelectFoldersWithBrokenFullPaths.sql script.

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

Client ID for IPV Device Director Service and Client Secret for IPV Device Director Service can be left blank. 

Choose Installation Destination

• .NET 4.7.2
• WebDeploy 3.6 - for the deployment of the Process Engine Monitor website
• 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

 Use WebDeploy to import the new version.

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

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:

%INSTALL_PATH%\Program Files\IPV\Process Engine Service\BundledModules\Workflows-Core-3.3.0.5.zip

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

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>

Find the AssetPopupInfo tag and add any missing tabs:

<AssetPopupInfo>
<Tabs>
<View name="Example MetadataView" display="Display Name" parent="false" />

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.