Updating the SQL Server Database for CML/LitCrit

If you've already installed the earlier version of the FmLib database in Scenario 1, you can use this procedure to update it. Note that you can create a completely empty database for this scenario using this same procedure. If you have existing data, skip the first procedure, and start with the one entitled "To upgrade/install the SQL Server tables and stored procedures."

To set up an empty SQL Server database

  1. Run the SQL Server Enterprise Manager. Do this by clicking the Windows® Start button 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.

We have provided a script that can either create tables if they do not exist, or update them by adding columns. The resulting database includes the tables and stored procedures necessary to run the CML/LitCrit sample application.

To upgrade/install the SQL Server tables and stored procedures

  1. Start a command prompt.
  2. Change the directory (using the CD command) to InetPub\wwwroot\FmLib\SQLScripts.
  3. 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 MyServer FmLib d:\mssql7\ftdata

    Note  The full 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 full path (including letter of the drive on which you installed the data files for full-text search during installation) of the Microsoft SQL Server version 7.0 full-text catalog. The rest of the parameters are automatically provided by the batch file.