How to create master script based on the sql outputs in different folders

[GoogleCodeExporter]

How to create master script based on the sql outputs in different folders.

we should have a provision to create a master script which will call all 
scripts generated for a schema in a particular order.

Any guess how could we achieve this.

Original issue reported on code.google.com by sarvindu...@gmail.com on 8 Jun 2013 at 2:46

[GoogleCodeExporter]

Original comment by resh...@gmail.com on 9 Jun 2013 at 8:21

• Changed state: Accepted
• Added labels: Type-Enhancement
• Removed labels: Type-Defect

[arno82]

My experience is, that it's nearly impossible to find a sequence of sql calls that work without errors because of dependencies between the files.

[xorader]

I used ddl2scheme.sh script from my fork https://github.com/xorader/scheme2ddl/tree/3.x_patches_from_xorader here.