Migrate an Oracle Database

If you used an Oracle database with the preceding InSight Rendering version and you want to use the same database with InSight Rendering 4.4 CHF 1 (you can reuse the database as long as the InSight Rendering version was InSight Rendering 3.1.5 CHF 3 or later), you must execute a PowerShell script named 4_4_0011.ps1 which will encrypt DMS logins. You do not need to rerun this script if you have already run it when installing InSight Rendering 4.4. The script is in both of these locations:
  • On the installation media at EnterpriseServices\Common\Liquent\Database
  • In the InSight Rendering installation location in the Database sub-folder.
The script uses information in the registry to connect to the database, so InSight Rendering 4.4 CHF 1 must already be installed.
  1. Click Start
  2. Click Search (magnifying glass), enter powershell.
  3. Select Windows PowerShell ISE (x86).
  4. Click File.
  5. Navigate to 4_4_0011.ps1 file.
  6. Run the script by clicking on the green arrow icon or by pressing F5.
    The passwords in the database are now encrypted.
  7. Close PowerShell.