Microsoft SQL Server

To run the scripts for Microsoft SQL Server:

  1. Start Microsoft SQL Server Management Studio. The SQL Server user you connect with must have database creation rights.
  2. Open a query window and paste in the contents of the database name_ CreateEmptyNavigationDatabase__SQLServer.sql script. For example:
    CPMNavigation_CreateEmptyNavigationDatabase_SQLServer.sql
  3. Execute the script.
  4. Connect as the navigation user created in the first script.
  5. Open a query window and paste in the contents of the database name_ CreateNavigationSchema_SQLServer.sql script. For example:
    CPMNavigation_CreateNavigationSchema_SQLServer.sql
    If you are creating the database for the first time, you will see a message when running this script. The script drops the tables and a message will display if the tables do not exist. The database is setup properly and the message can be ignored.
  6. Execute the script.

If you are overwriting an existing database, you can skip steps 2 and 3.