Creating and populating a database for assets in Microsoft SQL Server

These are the instructions for manually creating and populating tables for IBM® Rational® Asset Manager in Microsoft SQL Server.

Before you begin

Procedure

To create the database tables:

  1. Ensure that your ID has permission to execute CREATE SCHEMA statements. Typically, the database owner has this permission.
  2. Create a new database with database name RAMDB. The default collation option for SQL Server is case-insensitive; the Rational Asset Manager database must use a case-sensitive collation to work correctly. You must select a collation sequence that ends with_BIN2 (for example, Latin1_General_BIN2).
    From the command line tool, type:
    CREATE DATABASE RAMDB COLLATE collation
    where collation is where you specify a collation sequence. For example:
    CREATE DATABASE RAMDB COLLATE Latin1_General_BIN2 
  3. Execute the scripts that will populate the database.
    1. Open a command prompt.
    2. Type sqlcmd -d RAMDB -i path to SQL scripts\RAMSCHEMA_SQLServer.sql (where RAMDB is the name of the database that you created in step 2), and press Enter.
    3. Type sqlcmd -d RAMDB -i path to SQL scripts\bootStrap_SQLServer.sql (where RAMDB is the name of the database that you created in step 2), and press Enter.
  4. Verify that the tables were created.

What to do next


Feedback