Documentation Center

Creating the UGC database manually

Run manual SQL scripts to install the UGC database if you are installing a Microsoft SQL Server database in a Microsoft Azure SQL Database Cloud hosting environment.

Procedure

  1. Close all connections to your Microsoft SQL Server database server.
  2. Access your SDL Web installation media.
  3. Navigate to the folder Database\Scripts\MSSQL\Create\.
  4. Create the database by running the script called UGC_CREATE.sql as a database administrator user (sa). By default, the script creates a database called UgcDbName. To change this, edit the script to use a different name.
  5. If you changed the name of the database that the script created, edit the following scripts, changing the name UgcDbName to your chosen name throughout:
    • UGC_TABLES.sql
    • UGC_CONSTRAINTS.sql
    • UGC_INDEXES.sql
    • UGC_CREATE_LOGIN.sql
    • UGC_ALTER_LOGIN.sql
    • UGC_CREATE_USER.sql
  6. Run these scripts as a database administrator user (sa):
    • UGC_TABLES.sql
    • UGC_CONSTRAINTS.sql
    • UGC_INDEXES.sql
    • UGC_CREATE_LOGIN.sql
    • UGC_ALTER_LOGIN.sql (skip this script if you use the Microsoft Azure SQL Database hosting service).
    • UGC_CREATE_USER.sql
  7. Navigate to the the folder Database\Scripts\MSSQL\Shared\81\ and run the following script as a database administrator user (sa), again changing the database name if needed:
    • UGC_SET_VERSION.sql