SDB Creator Tool Syntax

Purpose

The SDB Creator tool syntax is used to create or update the SQLite, DBMS and Comms databases.

Syntax

  sdb [-h -l -v -k -d -m <mode value> -i <input-database-filename> -c <configuration-filename> -o <output- filename>
-p <filename> [<input file1> [<input file2> ...]]

The following options can be used:

OptionsDescription

-h

Displays the help message. It lists the options that can be used on the SDB Creator tool.

-l

Displays the list of modes and expected input files that can be used for each mode.

-v

Displays the tool version number

-k

Ignores SQL or CED execution errors during the creation of the database.

-d

Sets the logging output mode to DEBUG.

-m <mode-value>

Sets the mode of operation. The three modes that can be specified are:

  • sqlite

  • dbms

  • ced.<Symbian OS version>. For example, for Symbian OS v9.3, you must specify the mode as ced.93

-i <input-database-filename>

Specifies the input database file. To provide an existing database file as input, you must use this option.

-c <configuration-file>

Specifies the configuration XML file which contains settings for the SQLite and DBMS databases.

Note: This option is applicable only in sqlite and dbms modes.

-o <output-filename>

Specifies the output database file name and location using this option.

-p <filename>

Sets custom logging properties.

[<input file1> [<input file2> ...]]

Specifies input files.

In sqlite and dbms modes, you can specify an SQL file as input.

In ced mode, you can specify .cfg or .xml file as input.

Examples

The following are some example commands:

  • To create a database in sqlite mode by specifying a configuration file and an input file:

    > sdb -m sqlite -c sqlite_settings.xml input_data_schema.sql

  • To create a database in ced mode for Symbian OS v9.5 by specifying an input file:

    > sdb -m ced.95 input_ced.cfg

  • To update an existing database in dbms mode by specifying an input database file and an input SQL file:

    > sdb -m dbms -i exist_dbms.db -o updated_dbms.db input_data.sql

    The preceding command updates exist_dbms.db with the data in input_data.sql and stores it as updated_dbms.db.