Subject | RE: [firebird-support] Firebird metadata comparison |
---|---|
Author | Svein Erling Tysvær |
Post date | 2012-12-07T16:37:32Z |
>Is there some way I can compare the metadata between two databases?Some people attack this 'problem' the other way around. Somewhere in the database they store a version number. Every time they release a new version, they provide upgrade scripts from the previous version. Then, if you find an old version, it is just a matter of executing all upgrade scripts made since that version in chronological order.
>
>Really I'd like to implement configuration management for my Firebird user base, but I don't
>really know how to begin.
>
>Any ideas would be welcome.
I don't use this strategy myself (don't have external users and a handful of internal databases is not really a problem to manage), but it is an alternative worth considering (unless your users write DDL by themselves, leaving you with limited control over the database structure).
Set