Administration Guide > Installation > Changing the Database > Setting Up the Database

Setting Up the Database

The following document guides you through changing the databaseA database is an organized collection of data including relevant data structures. and setting up a new one.

Please refer to the advices of performance optimization before setting up the database (Configuration & Performance of the Database).

All the described working  steps refer to the installation of the MS SQL Server. Apply the adequate utilities and functions for Oracle or DB2 if these databases are used. Oracle uses two tablespaces (UC4_DATA and UC4_INDEX).

For Oracle Automic strongly recommends using the tablespaces UC_INDEX and UC_DATA only, as otherwise you would have to manually adjust all SQL files during an update process.

1. Requirements
2. Creating directory structure and starting the SQL Server

3.

Setting up the database

4. Creating the Data Source