Share this page
Prepare your database
Before installing a Deployment Automation server, set up your relational database.
Considerations
Your relational database is a critical element for performance and disaster recovery. Set up regular backups of the database.
Consult your database administrator to ensure that your database is configured for high availability and high performance.
For details about supported versions, see the Support Matrix.
Before installing Deployment Automation, you need to create an empty database in your DBMS.
If you are evaluating Deployment Automation, you can install the database on the same machine with the Deployment Automation server. Optionally, use the lightweight Derby database provided with the installer for evaluation purposes. If you select the Derby database, you do not need to prepare the database before running the server installer, and the database is created as part of the installation.
Create MS SQL Server database
For MS SQL Server databases, a clustered configuration is recommended.
When you are ready to install the Deployment Automation server, you need to provide the values you enter here, including the MS SQL Server connection information and the da user account that has table creation privileges.
To create an SQL Server database, run the following commands:
CREATE DATABASE da_database;
GO
USE da_database;
CREATE LOGIN da WITH PASSWORD = 'da_password';
CREATE USER da FOR LOGIN da WITH DEFAULT_SCHEMA = da_schema;
GO
CREATE SCHEMA da_schema AUTHORIZATION da;
GO
GRANT CREATE TABLE to da;
GO
Depending on the tasks you plan to designate to the da user account, you may grant more permissions, for example, BACKUP DATABASE, BACKUP LOG, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE VIEW, or others.
Create Oracle database
For Oracle databases, we recommend an architecture based on Oracle RAC.
When installing the Deployment Automation server, provide the values you enter here, including the Oracle connection information and the da user account that has table creation privileges.
Follow these instructions for your Oracle DBMS version.
Oracle 12 and later
To create a database in Oracle 12 or later, run the following commands:
ALTER SESSION SET "_ORACLE_SCRIPT"=true;
CREATE USER da IDENTIFIED by password;
GRANT CONNECT TO da;
GRANT RESOURCE TO da;
GRANT UNLIMITED TABLESPACE TO da;Oracle 10g or 11g
To create a database in Oracle 10g or 11g, run the following commands:
CREATE USER da IDENTIFIED by da;
GRANT CONNECT TO da;
GRANT RESOURCE TO da;Create PostgreSQL database
To create a PostgreSQL database, run the following commands:
CREATE DATABASE db_name
OWNER = role_name
TEMPLATE = template
ENCODING = encoding
LC_COLLATE = collate
LC_CTYPE = ctype
TABLESPACE = tablespace_name
CONNECTION LIMIT = max_concurrent_connection
See also:
