1.1.1

Syntax
To write a database schema as SQL commands to a file, use the syntax:
sqlf write-schema-to-sql -file=<path>
[-auth-provider=<name>]
[-bind-address=<address>]
[-catalog-pattern=<pattern>]
[-client-bind-address=<address>]
[-client-port=<port>]
[-database-type=<db type>]
[-delimited-identifiers=<true | false>]
[-driver-class=<class name>]
[-dump-from-db]
[-exclude-table-filter=<filter>]
[-exclude-tables=<name,name,...>]
[-extra-conn-props=<properties>]
[-help]
[-include-table-filter=<filter>]
[-include-tables=<name,name,...>]
[-isolation-level=<level>]
[-locators=<adresses>]
[-mcast-address=<address>]
[-mcast-port=<port>]
[-password[=<password>]]
[-schema-pattern=<pattern>]
[-to-database-type=<type>]
[-url=<url>]
[-user=<username>]
[-verbose=<level>]
[-xml-schema-files=<path,path,...>]
This table describes options for the sqlf write-schema-to-sql command. Default values are used if you do not
specify an option.
DescriptionOption
The full path of the file in which to store the SQL commands. This
argument is required.
-file
Sets the authentication provider to use for peer-to-peer connections
as well as client-server connections. Valid values are BUILTIN and
-auth-provider
LDAP. All other members of the SQLFire distributed system must
use the same authentication provider and user definitions. If you omit
this option, the connection uses no authentication mechanism. See
Configuring Authentication and Authorization on page 241.
The address to which this peer binds for receiving peer-to-peer
messages. By default sqlf uses the hostname, or localhost if the
hostname points to a local loopback address.
-bind-address
A string pattern that determines the database catalogs that sqlf writes.
sqlf does not use a default catalog pattern.
-catalog-pattern
To use a catalog pattern, specify a string value that describes the
catalogs that you want to write. Use the "%" character to match any
substring of 0 or more characters. Use the "_" character to match any
individual character.
425
sqlf Launcher Commands