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).

Not as a packaged solution. But you could easily write your own. If you know what the database scheme is, you can use standard SQL commands to query the database catalogue to get the objects within that schema and then for each object issue a SHOW CREATE <object type> <object name> to get the DDL. you could also wrap all of this up into a single stored procedure and call that. Once you have the text returned to you in Appian you can do what you like with it.

srihari.Gurram 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.