# Database Installation Tab

The Database Installation tab sets the installation settings for the on-premises database and the Protocol Server Store database.

## On Premise

Settings

1. In the Database Installation Settings, enter the sign-in information for the database:

   - Username

     SQL Server username.

   - Password

     SQL Server password.

   Ensure that the user has permission to create a database, users, and database jobs.

   The user account entered in this step is only used for the installation. The installer creates new users with limited access only to the Atlas Copco Data Communication database and the Atlas Copco Data Communication related database jobs.

2. Enter the folder path where the database files are going to be placed:

   - If the installation is local, select a location.

   - If the installation is remote, enter a location.

     Ensure that the folder exist on the targeted datasource address.

3. Verify the settings by selecting Verify Connection. The test connection will attempt to log in to the database using the credentials provided.

4. Select Next when the verification is successful.

Features

1. In the Feature Selection dialog box, select all features.

   It is recommended to run all the scripts in Feature Selection during an upgrade.

   If you are upgrading from an ACDC version earlier than 3.1, it is highly recommended to run the migration feature "Update Database job schedules for index maintenance" in order to upgrade the Database Job schedules for index maintenance.

2. Select Next.

Progress

3. In the Progress overview dialog box, all selected features from the Feature selection dialog box appears.

4. Select Execute to start the installation.

5. When the database installation is ready, select OK in the pop-up window.

6. Continue with next database installation if needed or close DataCommunication Installation Configurator by selecting Close.

## Protocol Server Store

The view and options in Settings depends on the selected Database Provider for Protocol Server Store in the Settings tab:

If the selected Database Provider is SQL Server

Settings

1. In SQL Server Database Installation Settings, enter the sign in information for the database:

   - Username

     SQL Server username.

   - Password

     SQL Server password.

2. Verify the settings by selecting Verify Connection. The test connection will attempt to log in to the database using the credentials provided.

3. Select Next when the verification is successful.

Ensure that the user has permission to create a database, users, and database jobs.

The user account entered in this step is only used for the installation. The installer creates new users with limited access only to the Atlas Copco Data Communication database and the Atlas Copco Data Communication related database jobs.

If the selected Database Provider is SQLite

Settings

1. In the SQLite Database Installation Settings, Database and Location are visible.

2. Select Next.

Features

1. In the Feature selection dialog box, select all features.

   It is recommended to select all the scripts in Feature Selection during an upgrade.

2. Select Next.

Migration Settings

1. In Alture migration settings, select the Migrate Alture sequence numbers checkbox to enable migration of data from Atlas Copco cloud to the Protocol Server Store.

2. In the On-premise database migration settings, select the Migrate on-premise sequence numbers checkbox to enable migration of legacy information from the SQL database to the Protocol Server Store and enter the sign-in information for the database:

   - Username

     SQL Server username.

   - Password

     SQL Server password.

3. Verify the settings by clicking the Verify Connection button. The test connection will attempt to log in to the database using the credentials provided.

4. Select Next.

Progress

1. In the Progress overview dialog box, all selected features from the Feature selection dialog box appears.

2. Click Execute to start the installation.

3. When the database installation is ready, click OK in the pop-up window.

4. Close the DataCommunication Installation Configurator by selecting Close.

## CDM

The Database settings for CDM are enabled (and required), if both On-premise and Unify are enabled.

Settings

1. In the Database Installation Settings, verify the Datasource and enter the Username and Password as the sign-in information for the database.

   - Username

     SQL Server username.

   - Password

     SQL Server password.

2. In Installation Folder, enter the folder path to store the database files.

   - If the installation is local, select a location.

   - If the installation is remote, enter a location.

   Ensure that the folder exists on the targeted datasource address.

3. Verify the settings by clicking Verify Connection. The test connection will attempt to log in to the database using the credentials provided.

4. Select Next when the verification is successful.

Features

1. In Feature selection, select all features.

2. Select Next.

There are currently no extra features available for CDM.

Progress

1. In Progress, all selected features from Features appear.

2. Select Execute to start the installation.

3. When the database installation is complete, select OK in the pop-up window.

4. Continue with next database installation if necessary, or close the DataCommunication Installation Configurator by selecting Close.

Relevant Information

- Troubleshooting During Installation