Microsoft SQL Server

To run the scripts for Microsoft SQL Server:

  1. Start Microsoft SQL Server Management Studio using the Run As Administrator command. The Microsoft 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_ ViewInitialize_SQLServer.sql script. For example:
    CPMViews_ViewInitialize_SQLServer.sql
  3. Execute the script.
  4. Repeat steps 2 and 3 for the database name_ ViewDefine_SQLServer.sql script. For example:
    CPMViews_ViewDefine_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.
  5. Open the Manage Data Sources page and add a data source for the Views database.
  6. Run the Views database utility and import view content.

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