Previous Topic: Review the Prerequisites for a SQL Server MartNext Topic: Microsoft SQL Server 2005 Permissions

Create a SQL Server Database

The following tasks must be performed by the DBA and system administrator responsible for installing CA ERwin Data Modeler Workgroup Edition on a Microsoft SQL Server DBMS:

  1. Use a graphical user interface (GUI) tool, ISQL (all versions), SQL Administrator, or Enterprise Manager to create the CA ERwin Data Modeler Workgroup Edition database. If a GUI tool is not available, you can use ISQL to type in the appropriate commands manually.

    Note: CA ERwin Data Modeler does not support creating a database in a Server Cluster environment.

    Your database should meet the following criteria:

    The new database is owned by the user who created it.

    Set the Truncate Log on Checkpoint option and have the server generate checkpoints frequently. By selecting this option, the log is emptied periodically and should not fill up and cause rollbacks.

    Note: For best performance ensure that separate devices are used to store the data and the transaction log.

  2. Verify tempdb size.

    Significant temporary space is required for installation and use. The temporary segments need at least 16 MB of available space. You should also increase available space as the number of concurrent users increase.

Back to Top