Generating DDL scripts

Generate a DDL script for a database in one of the following ways:
  1. Using the Tools > Reverse Engineer Database menu
  2. Selecting Script Database in the context menu of a database node in the object explorer tree
  3. Using the Object > Database > Script Database [database name] menu

Have more questions? Submit a request

1 Comments

  • 0
    Avatar
    Adam Woodcock

    Within the Aginity Workbench for Redshift tool, is there a menu setting, option, or preference to force Aginity Workbench to generate DDL CREATE statements to include the "ENCODE RAW" keywords when compression is not desirable?

    The schema comparison tool does recognize when compression differs, but if I want to reverse engineer the database, I'm losing the ENCODE RAW when I generate the DDL. Not sure if that is a bug or if I can request that as an additional menu option or new feature. Thanks.

Please sign in to leave a comment.
Powered by Zendesk