These are the instructions for manually
creating and populating tables for IBM® Rational® Asset Manager in Microsoft SQL Server.
Procedure
To create the database tables:
- Ensure that your ID has permission to execute CREATE SCHEMA
statements. Typically, the database owner has this permission.
- 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
- Execute the scripts that will populate the database.
- Open a command prompt.
- 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.
- 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.
- Verify that the tables were created.