This section explains how to create an environment for an asset management database.

To create an environment for an asset management database, use the Database Manager dialog box. After you have created an asset management database, perform the following tasks:

• Create an ODBC data source name (for Microsoft SQL Server and Embedded RDB)
• Create a net service name (for Oracle)
• Create a database
• Create a user for database access
• Initialize the database

To create an asset management database:

1. Click the Start button and point to Programs, then Asset Information Manager, and then choose Setup.
   The Setup dialog box appears.
   
2. Click the Database Manager icon.
   The following Database Manager dialog box appears.
   

   Figure 5-3 Database Manager dialog box (for Microsoft SQL Server and Oracle)

   

3. Select Create the database, and then click the Next button.
   The Basic Database Settings dialog box appears.
   
4. Set the database connection information and database area.
5. Create a database.

The setting of database connection information and database area in step 4 is described for each DBMS in subsections 5.4.1 through 5.4.3.

Organization of this section

5.4.1 How to create an asset management database (for Microsoft SQL Server)

5.4.2 How to create an asset management database (for Embedded RDB)

5.4.3 How to create an asset management database (for Oracle)

5.4.4 Estimating the database capacity