8.1. 3 to 8.2 upgrade experience (Oracle related)

Hi!

I've tried an upgrade of one of my lab machines from 8.1.3 to 8.2, database under linux.  We're using Oracle as one of our connected systems and handle some processes with Devart. We knew Devart was being deprecated.

A few tips:

  • The database update process ,only, took no less than 4 hours. Most of that time spent on EhE tables.
  • Before compilation, once you're prompted for authentication, you face an error: "Could not find referenced assembly Devart.Data.Oracle.dll" . I copied that dll and Devart.Data.dll  from one of my 8.1.3 installations and the upgrade recontinued flawlessly.
  • You'll need to lock any script using Devart if you want to reach the end of the update.

Hope this helps anyone trying it.

Have a great weekend!

  • I also did an update and I am facing an error that the license does not exist. Lincensing solution provided in dotConnect doc did not solve the issue. The client does not want to install dotconnect or buy licenses as they support they did not buy any licenses in the past and the that works fine in their current solution. Any ideas how to deal with that ? Have you seen an error like this? 

  • Starting with OneIM 8.2 Oracle.ManagedDataAccess is used in stead of Devart to connect to Oracle databases. Therefore OneIM 8.2 does not come with an Devart licence. You need to update scripts that reference Devart library to use Oracle.ManagedDataAccess. Syncprojects in ADO mode also need to be updated to use Oracle.ManagedDataAccess instead.