Adams Car Package > Adams Driveline > Configuring Your Product > Managing Databases

Managing Databases

Select a topic to learn about the operations you can perform on databases:

Creating Databases During a Session

You can create a new database anytime during a session. When you create a database, your template-based product adds it to its search list and places the database at the lowest level in its database search order. Your template-based product also creates database tables within the new database according to the table information stored in your private, site, and shared configuration files. Learn about search order.

Note:

Unless you save database changes to your private configuration file, Adams Solver will not be able to access the databases you added or created in a session

You should create a database for every project on which you are working. By creating separate databases for each project, you can ensure that the property files belonging to different subsystems are kept separate.

When you create a database, you define two elements for it:

■Name - You use the name, or database alias, to select the database from the search list in dialog boxes.

■Path - The location of the database in the file system.

Note:

You can also create databases directly using the configuration files. Learn about managing databases through configuration files.

To create a database:

1. From the Tools menu, point to Database Management, and then select Create Database.

2. Press F1 and then follow the instructions in the dialog box help for Create New Database.

3. Select OK.

Setting the Writable Database

You can set up one of your active databases as the repository for templates, subsystems, and property files. This database is called your default writable database. The default writable database is defined in your private configuration file, but you can change it at anytime during a session. You can select any database in the search list as your default writable database, as long as you have permission to write to the file system to which the database points.

To create a database:

1. From the Tools menu, point to Database Management, and then select Set Default Writable.

2. Press F1 and then follow the instructions in the dialog box help for Set Default Writable Database.

3. Select OK.

Managing Tables in a Database

You can add your own tables to a database. You use the configuration files to define the tables that you want to include in a database. Learn more about configuration files and table definitions in them.

Creating Tar Files of Databases

On Linux, you can create a tar file of any database that is listed in the search list. When you create a tar file of a database, your template-based product groups together all of the database's subdirectories and files into one tar file. It then writes the tar file to the default writable database using the name database_name.tar, where database_name is the name of the database you saved.

Saving a database as a tar file is an efficient way to save a snapshot of the current state of a database or to transfer the database to an external file system. You can easily transfer the databases through e-mail or through a file transfer protocol (ftp) process.

As you create a tar file, you can select to encode and compress the database using standard Linux compression and encoding techniques.

To create a tar file of a database in Linux:

1. From the Tools menu, point to Database Management, and then select Bundle Database.

2. Press F1 and then follow the instructions in the dialog box help for Bundle Database.

3. Select OK.