capture-schema(1M)             Utility Commands             capture-schema(1M)

NAME
       capture-schema - stores the database metadata (schema) in a file for
       use in mapping and execution

SYNOPSIS
           capture-schema -username name -password password
           [-dburl url] [-driver jdbc_driver_classname]
           [-schemaname schemaname] [-table tablename]
           -out filename]

DESCRIPTION
       Stores the database metadata (schema) in a file.

       Run capture-schema as the same database user that owns the table(s),
       and use that same username with the -username option (and -schemaname,
       if required).

       When running capture-schema against an Oracle database, you should
       grant the database user running the capture-schema command the ANALYZE
       ANY TABLE privilege.

OPTIONS
       -username
           user name for authenticating access to a database.

       -password
           password for accessing the selected database.

       -dburl
           JDBC URL required by the driver for accessing a database.

       -driver
           JDBC driver classname in your CLASSPATH.

       -schemaname
           name of the user schema being captured. If not specified, the
           default will capture metadata for all tables from all the schemas
           accessible to this user.

           Specifying this parameter is highly recommended.  Without this
           option, if more than one schema is accessible to this user, more
           than one table with the same name may be captured, which will cause
           problems when mapping CMP fields to tables.

           The specified schema name must be uppercase.

       -table
           name of a table; multiple table names can be specified. If no table
           is specified, all the tables in the database or named schema are
           captured.

           The specified table name or names are case sensitive. Be sure to
           match the case of the previously created table names.

       -out
           name of the output file. This option is required. If the specified
           output file does not contain the .dbschema suffix, it will be
           appended to the filename.

EXAMPLES
       Example 1, Using the capture-schema command

               capture-schema -username cantiflas -password enigma
               -dburl jdbc:oracle:thin:@sadbuttrue:1521:ora817
               -driver oracle.jdbc.driver.OracleDriver
               -schemaname CANTIFLAS -out cantiflas.dbschema
           Where: sun-acc.xml is the name of the client configuration XML
           file, myclientapp.jar is the client application .jar file, and
           scott and sample are arguments to pass to the application. If
           sun-acc.xml and myclientapp.jar are not in the current directory,
           you must give the absolute path locations; otherwise the relative
           paths are used. The relative path is relative to the directory
           where the command is being executed.

SEE ALSO
       asadmin(1M)

Jakarta EE 11                         1 Dec 2011                capture-schema(1M)
