Skip to main content

5 replies

Participating Frequently
Nov 15, 2022 2:33 PM UTC

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

sriharig758857
New Participant
Nov 16, 2022 6:33 AM UTC

Hi  Laurens Weijzig,

we need to automatically backup the appian cloud schema

Participating Frequently
Nov 16, 2022 9:54 AM UTC

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

stewart.burchell
Employee
Nov 16, 2022 11:29 AM UTC

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.