Help Center> Data Warehouse Service> Tool Guide> Data Studio - Integrated Database Development Tool> Schemas> Exporting Schema DDL and Data
View PDF

Exporting Schema DDL and Data

Exporting the schema DDL and data exports the following:

  • DDLs of functions/procedures of the schema.
  • DDLs and data of tables of the schema.
  • DDLs of views of the schema.
  • DDLs of sequences of the schema.

Follow steps below to export the schema DDL and data:

  1. In the Object Browser pane, right-click the selected schema and select Export DDL and Data.

    The Data Studio Security Disclaimer dialog box is displayed. You can close this security disclaimer message. Refer to Security Disclaimer section for more information.

  2. Click OK.

    The Save As dialog box is displayed.

  3. In the Save As dialog box, select the location to save the DDL and data and click Save. The status bar displays the progress of the operation.

    • To cancel the export operation, double-click the status to open the Progress View tab and click . For more information refer toCanceling the export table data operation.
    • The exported file name will not be the same as schema name, if the schema name contains characters which are not supported by Windows.
    • Microsoft Visual C runtime file (msvcrt100.dll) is required to complete this operation. Refer to Troubleshooting section for more information.

    The Export message and the status bar display the status of the completed operation.

    Database Encoding

    File Encoding

    Supports Exporting DDL

    UTF-8

    UTF-8

    Yes

    GBK

    Yes

    LATIN1

    Yes

    GBK

    GBK

    Yes

    UTF-8

    Yes

    LATIN1

    No

    LATIN1

    LATIN1

    Yes

    GBK

    No

    UTF-8

    Yes

    Multiple objects can be selected to export DDL and Data. Refer to Batch Export section for list of objects not supported for export DDL and Data operation.

Parent topic: Schemas