Subject Re: [firebird-support] Distributing/deploying Stored Procedures
This is a age old problem, I try to address it in my platform, this was inspited by the way Flamerobin, does the DDL extract, create procedures / then later alters them with actual content, to avoid inter dependencies.

The main pain point is, referral integrity, is not catered for yet, it would make it a lot more complex.

It does things like optionally reordering columns to match, adding or removing defaults...

Don't run on production databases without backups and careful testing.