Running Database Administration Tool from a command prompt

Windows syntax

strs-migrate.bat [-a <arg>] -d <arg> [-f] [-i <arg>] [-m <arg>] [-n <arg>] [-o <arg>] -p <arg> [-s <arg>]-u <arg> [-y] [-z <arg>] [-x <arg>] [-b <arg>]

UNIX syntax

strs-migrate.sh [-a <arg>] -d <arg> [-f] [-i <arg>] [-m <arg>] [-n <arg>] [-o <arg>] -p <arg> [-s <arg>]-u <arg> [-y] [-z <arg>] [-x <arg>] [-b <arg>]

Parameters and arguments

The parameters are described below. You can use the short (-a, -d, etc.) or long version (--area, --dbtype, etc.) of the parameters.

Parameter	Argument	Description
-a --area	Security Composer CompositionCenter MessageStore	Areas in a runtime repository to export. If this parameter is omitted, all areas are included in the export. You can enter one or more of the following areas as argument: • Security – Roles, permissions, etc. • Composer – Resources used in Composer. The Security area is also included. • CompositionCenter – Resources used in Composition Center. The Security area is also included. • MessageStore – Stored Messages. The Security and CompositionCenter areas are also included. Use the following syntax to specify several areas: Security[|Composer][|CompositionCenter]
-d --dbtype	ORACLE MSSQL	Database vendor.
-f --force	N/A	Forces data overwrite when importing data to a runtime repository.
-i --instance	<InstanceName> <SID>	Database instance to connect to. Enter one of the following as argument: • <InstanceName> for SQL Server. • <SID> for Oracle.
-m --mode	DOCTYPE INSPECT EXPORT IMPORT MIGRATE	Mode. Enter one of the following as argument: • DOCTYPE Export document types and metadata to xml file. Not applicable to repositories version SP5 or later. • INSPECT Inspect repository. • EXPORT Export repository data to a zip file. • IMPORT Import repository data from a zip file. • MIGRATE Import repository data from a zip file (used when migrating data from e.g. test to production environment in 5.6).
-n --schema	<DatabaseName> <SchemaName>	Database to connect to. Enter one of the following as argument: • <DatabaseName> for SQL Server. • <SchemaName> for Oracle.
-o --port	<port>	Port. Enter the appropriate port number as argument. Default is 1433 for SQL Server and 1521 for Oracle.
-p --password	<password>	Database user password. Enter the appropriate password as argument.
-s --servername	<hostName>	Host of the database. Enter the appropriate host name as argument. Default is localhost.
-u --user	<userName>	Database user. Enter the appropriate user as argument. Note: The user must have privileges equal to database/schema owner.
-y --yes	N/A	Suppresses Database Administration Tool from asking for user confirmation. With this option, you can run Database Administration Tool in batch mode on multiple repositories.
-z --path	<path>	Specifies a path: • Mode EXPORT: Path to the zip file to export. • Mode IMPORT and MIGRATE: Path to the zip file to import. • Mode DOCTYPE: Path to the xml file to export. Enter the appropriate path as argument.
-x --doctypes	<path>	Used in mode IMPORT when importing Composition Center resources from a pre-SP5 web content repository to an 5.6 web content repository. This parameter specifies the path to the document types file that must be used when importing the resources. For example: -x C:\doctypes\document_types.xml
-b --docdefbatch	<path>	Used in mode EXPORT to export document definitions from a runtime repository or web content repository to a zip file. The argument is a path to an xml file that defines which document definitions to export.