Upgrading an Ouvvi v2.5 instance to the latest v4.0 version requires.
Caution: Please ensure you have a backup of the Ouvvi Database incase you need to go back to the previous version.
First stop any Ouvvi Service(s) via Windows Service Control Manager (services.msc).
To copy the Ouvvi v4 Web and Service files and remap the Database connection from the old
ouvvi.config file use the following PowerShell Script.
-Url with your existing Ouvvi configuration values.
# Import Ouvvi PowerShell Module Import-Module OuvviAdministration # Upgrade Instance Install-OuvviUpgrade -targetPath C:\OuvviTenants\Default -Url http://localhost:8080
To upgrade the DB Schema you will need the OuvviWeb App Pool user or Ouvvi DB User to be a DB Owner on the Ouvvi DB Instance for the DB Schema Upgrade.
We have a PowerShell CmdLet below that will set a DB User account as owner providing the calling process user is a SQL Server Administrator.
-userName with your existing Ouvvi configuration values.
Alternatively you can set the user as DBO with SQL Server Management Studio via
exec sp_addrolemember 'db_owner', 'userName'.
# Import Ouvvi PowerShell Module Import-Module OuvviAdministration # Set DB User as Owner Set-OuvviDBUserDBOwner -targetPath C:\OuvviTenants\Default -UserName "OUVVIV4\Ouvvi"
Next for the Actual DB Upgrade, open your browser to the Ouvvi Setup page i.e.
http://localhost:8080/setup. Check the settings and press the Update Schema button to open the schema upgrade tool.
Press 'Upgrade Database' to migrate the DB to the new DB Schema.
Verify the Ouvvi URL is correct for the Windows Service open the configuration file
<TENANTPATH>\Service\Simego.Console.Service.exe.config in a text editor and update the OuvviServiceUrl value if necessary. (default value is http://localhost:8080)
Next the Ouvvi Windows Service should be configured to run under a network domain account and started (this account will be used as the security context to run the steps) to do this open the services control panel (services.msc) and configure the Ouvvi Processing Service for your tenant and set the Startup type to Automatic (Delayed Start).
The Ouvvi Service can run under NETWORK SERVICE if you only need to connect to internet and local machine resources.
Verify that your services are all running under
Services->System Services green flags indicate that the service is running OK.
By default the service are configured to start on the local machine you can add new Service Agents here and define the machines that they should run on.
Install your Data Synchronisation Studio - Server License Key under
Settings->Register License to activate Ouvvi.
Ouvvi will not run any projects and steps without a valid license key installed.