Skip to main content
Version: 15.1

Create Database

A new database can be created as follows:

  • Automated with SQL Server or PostgreSQL

    Administrator rights to the SQL Server instance or to the PostgreSQL database server are needed.

  • Manually with SQL Server

    Administrator rights to the SQL Server instance are needed.

  • Manually with Oracle

    Administrator rights to the Oracle database server are needed.

  • Manually with PostgreSQL

    Administrator rights to the PostgreSQL database server are needed.

Default User

During the creation of the database, a user account is created automatically: The user Admin (with the starting password password) is a super user for administrating ADOIT.

Detailed Instructions

For detailed instructions on how to create a database with SQL Server 2012/2014/2016/2017/2019/2022 or Oracle 12c/18c/19c, refer to the database manuals on the ADOIT installation medium in the folder “01 Installation Manual”.

For detailed instructions on how to create a database with PostgreSQL, refer to Creating a PostgreSQL Database

Quick guide: Automated with SQL Server or PostgreSQL

  • Start the ADOIT-tool Create new database in the windows start menu or execute the file adbinstws.exe in the ADOIT installation directory.

  • Select Create new database, fill out the available fields, keep the default settings and click Create.

Quick guide: Manually with SQL Server

  • Create an empty database hull with the SQL Server Management Studio.

  • Establish an ODBC-data source. For details, see the information box below.

  • Initialize the database (see Initialize Database).

note

You must create the ODBC data source by using the 64-bit version of the odbcad32.exe file located in the “%WINDIR%\system32” folder. “%WINDIR%” stands for your Windows installation directory.

Quick guide: Manually with Oracle

  • Run the Oracle Database Configuration Assistant.

  • Create a net service name.

  • Modify the script aprporcl.sql and run it with SQL Plus.

  • Initialize the database (see Initialize Database).

Quick guide: Manually with PostgreSQL

  • Create a database with pgAdmin.

  • Establish an ODBC-data source.

  • Initialize the database (see Initialize Database).

note

You must create the ODBC data source by using the 64-bit version of the odbcad32.exe file located in the “%WINDIR%\system32” folder. “%WINDIR%” stands for your Windows installation directory.