The last step in configuring CAPTUREit Server to use a user specified database is to create the initial tables and views in the database. For security reasons, many Database Administrators prefer table and index creation be handled by an administrator rather than by an application.
When you click Generate Database Creation Scripts in the CAPTUREit Server Properties window, CAPTUREit Server generates an SQL script named CAPTUREit_SQL.sql. Run this script to create the necessary CAPTUREit Server tables. The administrator can modify the script, if necessary, to account for specific user privileges. This is an example of how to run an SQL script using Microsoft SQL Server.
To generate database creation scripts:
- Run SQL Analyzer, which is distributed with Microsoft SQL Server. To run SQL Analyzer directly from Enterprise Manager, from the Tools menu, click SQL Analyzer.
- When prompted for the server name, select the same server you chose when you configured the CAPTUREit Server database.
- From the drop down menu, select the database in which to run the script.
- After the database is selected, open the CAPTUREit_SQL.sql file.
- Make any permission or security changes to the SQL script. Do not change the commands that define the table structures; the system may not work properly.
- Press F5 to run the script. A message appears saying that all commands were run successfully. This means that all tables, indexes, and views have been created and the database is ready to accept CAPTUREit Server data.