Specific prerequisites for PowerShell database scripts
PowerShell database scripts can run on any operating system that contains the general PowerShell prerequisite software, so long as it supports any database client software that is required. All SDL Web 8.5 server machines running Windows always meets these requirements.
- Operating system
-
The machine(s) on which you run PowerShell scripts to install or upgrade databases must have an operating system that contains the general PowerShell prerequisite software and that supports any Oracle or SQL Server client software for the database you inted to install. All supported Windows operating systems for SDL Web 8.5 servers meet these requirements, so you can always run the scripts from your Content Manager server. However, any other machine that meets these requirements can also be used.
- Database client software
-
If you intend to install or upgrade an Oracle database, you must also have the 64-bit versions of the following Oracle client software installed on the machine:
- Oracle Services for Microsoft Transaction Server (ORAMTS)
- Oracle Data Provider for .NET (ODP.NET)
For maintenance, configuration and debugging purposes, SDL recommends that you also install the following Oracle client software:- SQL*Plus
- Oracle Net