Products Support Documentation Download
rdm-create: Database Creation Tool
Synopsis
rdm-create [OPTION]... dbname.sdl
Description

rdm-create is a command-line utility that creates an RDM database from a database definition file (*.sdl). The database will not be populated with data.

The database will be created in the current working directory by default. A command-line option (--tfs) is provided to allow the database to be created on a remote TFS (See rdm-tfs).

Options
OptionsDescription
-h, --helpDisplay this usage information
--versionDisplay the version information
-q, --quietQuiet mode. No information will be displayed
--key=keySpecify the encryption key for the database ([algorithm:]passcode). The valid algorithm selections are:
xor XOR encryption key
aes128 128 bit AES encryption key
aes192 192 bit AES encryption key
aes256 256 bit AES encryption key
Note
The AES algorithms are only available for packages that have strong encryption support. If an algorithm is not specified, the default is aes128 for strong encryption packages and xor otherwise.
--docroot=pathDocument root under which to place database files (See Document Root (docroot))
-f, --forceOverwrite existing target
-L, --locale=localeThe string collation locale the database will use (See locale)
-o, --output=db-uriThe database to be created. A db-uri without a database base name implies the dbname specified for the input file.
dbname.sdlName of database definition file (*.sdl)
Usage Examples

The usage examples assume that bookshop.sdl contains the following table definition:

CREATE TABLE author
(
    last_name CHAR(13) PRIMARY KEY,
    full_name CHAR(25),
    gender    CHAR(1),
    yr_born   SMALLINT,
    yr_died   SMALLINT,
    short_bio VARCHAR(216),
    KEY yob_gender_key(yr_born, gender)
);
Creating an RDM database

You can run rdm-create to create an RDM database from a database definition file.

$ rdm-create bookshop.sdl

An RDM database, bookshop, will be created as the result. The database consists of its own directory named bookshop.rdm in which the internal database files will be stored.

To create a database named 'myBookshop' on a remote TFS named 'myRemote':

$ rdm-create --output=tfs://myRemote/myBookshop bookshop.sdl