Documentation Center

Creating a Microsoft SQL Server Experience Manager database manually

Create your Microsoft SQL Server Experience Manager database manually by running database scripts that create the database and its tables.

Procedure

  1. Close all connections to your Microsoft SQL Server database server.
  2. Access your SDL Tridion installation media.
  3. Navigate to the folder Database\Scripts\MSSQL\Create\ and run the following scripts:
    • CD_BROKER_CREATE.sql
    • CD_BROKER_TABLES.sql
    • CD_BROKER_CONSTRAINTS.sql
    • CD_BROKER_INDEXES.sql
    • CD_BROKER_DATA.sql
    • CD_WAI_TABLES.sql
    • CD_WAI_CONSTRAINTS.sql
    • CD_WAI_INDEXES.sql
  4. Navigate to the folder Database\Scripts\MSSQL\Shared\71\ and run the following script\:
    • GENERAL_SET_VERSION.sql

Results

You have created the Experience Manager database.

What to do next

When installing the Experience Manager Server Role, you configure the Experience Manager database in the Storage Layer configuration file.