Overview

The methodology when installing database management systems (RDMS – Relational Database Management System) vary from vendor to vendor depending on the host server chosen and the operating system.

Generally you would require system administration rights to the host server. Installation and configuration would utilize the 'super' user such as 'sa'.

The database software could be supplied on CD/DVD such as Oracle, Sybase and Microsoft SQL Server and installed on either Windows Server or Unix/Linux architecture as appropriate. Paid license(s) are required unless installing a 'Developer' or 'Trial' edition for non production use.

Open Source

For Open Source databases such as MySQL and PostgreSQL, repositories exist on their vendor websites and other relevant supportive websites. The source software can come in the form of binaries, compressed archives (tarballs) or specific operating system packages such as an 'rpm' for Red Hat Linux.

Installation should be a straight forward procedure but sometimes requires additional changes to the server as required if any server configuration or bespoke changes on the system have been made. Customization may be required for disk allocation, system usernames utilized and the configuration for alternative ports and firewalls etc. Once the database server software is installed, further configuration may be required to make accessible on your business network.

Popular Vendors:

Oracle
Sybase
Microsoft SQL Server
PostgreSQL
MySQL
DB2
Informix