Setting Up an Empty Database

Use these steps to create an empty database called FmLib. To create a database with the CML sample data, see Setting Up a Database with Sample Data.

Important Installation Note  The following two installation scenarios are possible:

• If you are installing the files for the CML application (for the BDG's Scenario 1), in step 1 of the following procedure use the setupSQL.bat file in the Samples\FmLib\SQLScripts folder.
• If you are installing the files for the CML/LitCrit application (for the BDG's Scenario 2), in step 1 of the following procedure use the setupSQL.bat file in the Samples\LitCrit\FmLib\SQLScripts folder.

To set up an empty SQL Server database

1. Run the SQL Server Enterprise Manager. Do this by clicking Start and clicking Programs. Then, point to Microsoft SQL Server 7.0 and then click Enterprise Manager.
2. Expand the Microsoft SQL Servers node, expand SQL Server Group, and click the node of your server.
3. Right-click the Databases folder and click New Database.
4. Type FmLib in the Name text box and locate the new database on an NTFS drive.
5. Be sure Automatically grow file is selected.
6. Click the Transaction Log tab. Under Maximum file size, click Restrict filegrowth (MB), and enter a value of 120.
7. Click OK to create the database.
8. Start a command prompt.
9. Type the following and press ENTER.

   cd InetPub\wwwroot\FmLib\SQLScripts 
   

10. Run the setupsql.bat file. This batch file sets up the SQL Server database. An example of the command syntax for the setupsql.bat batch file is:

    setupsql.bat <SQLServerName> FmLib d:\mssql7\ftdata
    

    

    Note  The syntax for this batch file is:

    setupsql.bat <SQLServerName> DataBaseName Full-Text_Catalog_Path SA_Account SA_Password
    

    When you run this batch file, provide the server name and database name (FmLib). The data location should point to the letter of the drive on which you installed the data files for full-text search during installation of Microsoft SQL Server version 7.0 (or Microsoft BackOffice Server version 4.5). The rest of the parameters are automatically provided by the batch file.

The resulting database includes tables and stored procedures necessary to run the CML sample application. Upon running the batch file the database is created and consists of FmLib data and stored procedures necessary to run the CML sample application.