These are the instructions for manually
creating tables for IBM® Rational® Asset Manager in Microsoft SQL Server.
Before you begin
- Ensure that SQL Server 2005, 2008 or 2008R2 is installed and running.
- Install one of the following drivers on the
SQL Server that runs Rational Asset Manager.
For both drivers, the JDBC .jar file is sqljdbc4.jar.
- Make sure that you know the location of the SQL scripts. Typically,
the location is: path_to_installation_media\db_scripts\SQLServer.
- Use SQL Server Authentication available as part of Mixed mode
(Windows Authentication and SQL Server Authentication).
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). To learn more about
collation options, see Windows Collation Name on the Microsoft website.
You
can create databases using the command line tool. To start the command
line tool, at a command prompt type sqlcmd -U login_id -P password.
From
the command line tool, type:
CREATE DATABASE RAMDB COLLATE collation
GO
where
collation is where you specify
a collation sequence. For example:
CREATE DATABASE RAMDB COLLATE Latin1_General_BIN2
GO
- Use the server setup application to populate the database.
To learn more about the server setup application, see Installing Rational Asset Manager server by using Installation Manager.
- Verify that the tables were created.