Documentation Center

Creating the Topology Manager database

Topology Manager Server requires a Topology Manager database. Use a PowerShell script to create a Microsoft SQL Server or Oracle database. (The prerequisites for a Topology Manager database are identical to those of a Content Manager database.)

Before you begin

Database server
Before running a PowerShell script:
  • On Oracle—make sure that there are no open database connections and configure the Oracle database server.
  • On Microsoft SQL Server—configure the Microsoft SQL Server database server.
Database credentials
PowerShell scripts prompt you for the following information:
  • DBA and user credentials (unless you created an Oracle SDL Web administrator user)
  • the server and port number (if non-standard) where your database server resides
Database details
PowerShell scripts prompt you to provide the following information which you will need to store in a safe place along with Database credentials as you will need it when you install and configure the Content Manager and Content Delivery:
  • the name of the database
  • the name of the database user
PowerShell scripts provide default database names and user names, or you can enter your own.

Procedure

  1. Open Windows PowerShell from the Windows Start Menu.
  2. In PowerShell, depending on your database navigate to one of the following folders on the installation media:
    • For a Microsoft SQL Server, AWS RDS-MSSQL or Microsoft Azure database, navigate to Database\MSSQL\
    • For an Oracle database, navigate to Database\Oracle\
  3. Type the following command:
    & '.\Install Topology Manager database.ps1' 
  4. Follow the instructions in the PowerShell console to install the database.

Results

You have created the Topology Manager Database.