EMS Schema Export Tool
Each database store that is configured for an EMS server includes a configuration parameter pointing to a database. The EMS Schema Export Tool creates and exports database tables for the database stores. Database administrators can use the Schema Export Tool to selectively export and tune schemas to suit your database and messaging system.
dbstore
are configured, you must export the database schema before starting the EMS server.
The Schema Export Tool is a JAR file,
tibemsd_util.jar
, located in the same directory as
tibemsd
. Command line options, described in
EMS Schema Export Tool Options, determine whether database tables are created or dropped, and whether they are printed to the console, saved to a file, or exported to the database.
Before invoking the Schema Export Tool, you must:
- Configure the global database store parameters for the EMS server. The parameters that configure the global database store settings begin with
dbstore_
. See Configuration in tibemsd.conf for details about these parameters. - Configure at least one store of type
dbstore
. See Configuration in stores.conf for more information about configuring database stores.