Upgrading the Access Management database
If you have Access Management installed as a part of your implementation, upgrade your existing Oracle or Microsoft SQL Server database by running a PowerShell script.
Before you begin
To upgrade the Access Management database itself, you need details of DBA and user credentials and the name of the database.
- PowerShell
- You require Microsoft Windows PowerShell 5.1. You can download Microsoft Windows Management Framework 5.1, which includes Microsoft Windows PowerShell 5.1, from this location: http://aka.ms/wmf5download
- Operating system
- You require an operating system that supports both the required PowerShell software and any software for the database you intend to install. As a general rule, ensure that the latest (security) updates are installed on your operating system.
- Database client software
-
For Oracle databases, you require both of the following:
- Oracle Services for Microsoft Transaction Server (ORAMTS)
- Oracle Data Provider for .NET (ODP.NET)
- Environment variables
-
For Oracle databases where you have defined a Net Service Name for each database in a tnsnames.ora file, you must also have defined a
TNS_ADMINenvironment variable. Set it to the directory where tnsnames.ora resides. - Microsoft .NET Framework
-
You require a .NET Framework version. The one to use depends on your Windows Server operating system version:
- If you run Microsoft Windows Server 2022, you can use Microsoft .NET Framework 4.8.1. You can download Microsoft .NET Framework 4.8.1 from the following location: https://dotnet.microsoft.com/en-us/download/dotnet-framework/net481
- If you run Microsoft Windows Server 2019 x64, you must use Microsoft .NET Framework 4.8. You can download Microsoft .NET Framework 4.8 from the following location: https://dotnet.microsoft.com/en-us/download/dotnet-framework/net48
- Security
- You need to be logged in as a user with sufficient security clearance. For example, to run a script that installs a database, you must be logged in as a user with rights to create that database.
Procedure
What to do next
If you encounter problems during the upgrade, restore your backup and try again. If your second attempt fails as well, consult RWS Customer Support for assistance. Do not attempt to fix the database.