Exporting a query or query results

You can export a query or query results to the file system. Exporting a query is useful for transferring queries from one database to another and for sharing queries amongst colleagues. You can use exported query results as input to other applications.
To transfer a query from one database to another, both databases must use the same schema.

To export a query or query results to the file system:

  1. Right-click the query in the Navigator view and click Export Query or Export Records, as appropriate.
  2. In the Export Query window, navigate to the location in which to save the export file. You can rename the file, if desired. Then click Save.
Related concepts
About records
Record states and state transitions
Record types
About queries
About query filters
Related tasks
Submitting a record
Creating a record template
Loading and updating a record template
Exporting record templates
Importing record templates
Modifying a record
Changing the state of a record
Marking a record as a duplicate
Finding a record
Viewing the history of the Find Record command
Printing a record or result set
Exporting records
Creating and running a query
Editing a query
Editing a query as SQL text
Running a query
Setting a query to run at startup
Importing a query

Feedback