Appian Data Base Script

There are options to download DDL scripts in Appian. Can you please explain your use case more?

Hi  Laurens Weijzig,

we need to automatically backup the appian cloud schema

This can be anchored best in your CICD pipeline/activities. Document the scripts for each table once and update at eah relevant release (those including adaptations to DB schema).

Unknown said:

appian cloud schema

FWIW, appian cloud instances have nightly snapshots with archives going back quite some way (i'm unclear on exctly how far back, etc, though it might be months or years).  Generally this should mean you don't have to worry about doing your own DB-level backups; if you have any particularly important table data the suggestion I'd make would be to do periodic targeted data dumps in one of various different ways, including simply exporting data to CSV/excel files.

Unknown said:

appian cloud schema

FWIW, appian cloud instances have nightly snapshots with archives going back quite some way (i'm unclear on exctly how far back, etc, though it might be months or years).  Generally this should mean you don't have to worry about doing your own DB-level backups; if you have any particularly important table data the suggestion I'd make would be to do periodic targeted data dumps in one of various different ways, including simply exporting data to CSV/excel files.