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.

Note: The EMS Schema Export Tool must be used to export database tables when one or more database stores are configured. That is, if any stores of type 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.