Appian Data Base Script

Certified Senior Developer

Is There Any Smart Service For Download DDL scripts In Appian

  Discussion posts and replies are publicly visible

Parents
  • 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.

Reply
  • 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.

Children
No Data