Skip to main content
sriharig758857
sriharig758857
November 15, 2022
Question

Appian Data Base Script

  • November 15, 2022
  • 5 replies
  • 0 views

Is There Any Smart Service For Download DDL scripts In Appian

5 replies

L
laurensw425805
November 15, 2022

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

sriharig758857
sriharig758857Author
November 16, 2022

Hi  Laurens Weijzig,

we need to automatically backup the appian cloud schema

L
laurensw425805
November 16, 2022

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
stewart.burchell
November 16, 2022

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.

Terms & ConditionsAccessibility statement