Export Applications and Components

The ExportApp utility lets you copy an entire application from the database to an export file in text or XML format. You can later import it from the export file into a database. The easiest method of accessing the ExportApp utility is from the Workbench Develop tab.

1. Select the application that you want to export in the Applications portlet of the Develop tab.

See the descriptions for each of these parameters in Parameters for the ExportApp Utility.

You can specify the following export parameters using the Export Application dialog:

Specifies the format of the file to be exported:

Specifies whether metadata (AlterBy, AlterDate, Creator, CreateDate) should be exported with the application. If this parameter is not set, OpenROAD assigns no metadata to the exported application. To use this parameter, you must also specify XML as the file input format.

Specifies the name of the file to which the application will be exported. By default, the name of the application is provided; overwrite this to change it. Click Browse to display a standard File Selection dialog so that you can save the file to a different location.

Specifies that only application source information (application properties and included applications) will be included in the export file; no component information will be written to the file. Selecting this option is useful when you want to recreate an empty application from an empty export file before importing its components.

Lets you use this command as if you were another user, username.

• This entry field can be used only if Execute in Background is enabled.

Specifies the name of a log file. This entry field can be used only if Execute in Background is enabled and Trace Window is set to Yes. If the log path specified is not a full path, the file is created in the ingres\files directory.

Lets you control display of the Trace window by entering one of the following values:

Specifies that the Trace window appears but suppresses informational messages output by the system

Specifies that the Trace window does not appear, and a log file is not created

Note: This entry field can be used only if Execute in Background is enabled.

Appends the trace output of the current command to the end of the existing error log file. Otherwise, that log file is replaced. This entry field can be used only if Execute in Background is enabled.

Note: The error log file, w4gl.log, is located in %USERPROFILE%\AppData\Local\OpenROAD\Profiles\installation_ID. If the -L flag is passed, a new name and location can be provided for the OpenROAD log file.

Begins a new process while you are using this utility.

If enabled, Execute in Background makes Username, Log Path, Trace Window, and Append to Log File available for use.

Note: You can set defaults for this utility using the Set Tool Defaults dialog. see Set Defaults.

Command Line Method of Exporting an Application to a File (BackupApp)

To export an application to a file using the command line, enter the following command at the command line:

w4gldev backupapp out database application file [-appsource] [-nowindows]
[-xml [-xmeta]] [-uusername] [-Lfilename] [-vversion]
[-T{yes|yes,min|yes,logonly|all|all,min|all,logonly|no}] [-A] [-t]

For more information about including default attribute values and indenting XML elements when exporting, see Effect on File Size of Including Default Attribute Values and Indenting XML Elements.

Note: The following parameters and flags are available from the command line:

Specifies the export mode of the BackupApp utility

Specifies the name and location of the database in which the application resides

Specifies the name of the application to export

Specifies the name of the file to which the application will be exported

Lets the application run without the window manager running. This option does not provide full batch mode execution, because some interaction with the application still may be required through the Trace window.

Specifies XML format

Specifies whether the original XML metadata (AlterBy, AlterDate, Creator, CreateDate) is exported to the XML component file. If this parameter is not included, OpenROAD assigns new metadata to the exported component. To use this parameter, you must also specify -xml as the file output format.

Lets you use this command as if you were another user, username.

Specifies the name of a log file. If the log path specified is not a full path, the file is created in the %II_SYSTEM%\ingres\files directory.

Specifies the version of the application to export

Controls the display of the Trace window by entering one of the following values:

Specifies that the Trace window appears but suppresses all informational system messages

Specifies that the Trace window appears minimized as an icon, and all informational system messages are suppressed

Specifies that the Trace window does not appear, but all messages are saved in a log file without informational system messages

Specifies that the Trace window does appear and all messages are written

Specifies that messages are written to the Trace window, which appears minimized as an icon

Specifies that the Trace window does not appear, but all messages are saved in a log file

Specifies that the Trace window does not appear, and no log file is created

Appends the trace output of the current command to the end of the existing error log file.

Note: The error log file, w4gl.log, is located in %II_SYSTEM%\ingres\files.

Specifies that transactions are committed after each component is deleted from the database

IMPORTANT! Using this parameter decreases contention and log file use. However, if your database server terminates abnormally or the BackupApp utility is aborted before completion, only some of the application components are exported.

An exit code of zero (0) means success; a non-zero exit code indicates an error.

The following example exports the working version of all components in the “myapplication” application in the database “mydatabase” to the export file “myapp.bck” in OpenROAD text format:

The following example exports the working version of all components in the “myapplication” application to the export file “myapp.xml” in XML format with metadata:

w4gldev backupapp out mydatabase myapplication myapp.xml -xml -xmeta

The following example exports only application source information (no component information) to the export file “myapp.xml” in XML format without metadata:

w4gldev backupapp out mydatabase myapplication myapp.xml -appsource -xml