Subject Re: [ib-support] Disappointed in Interbase (long)
Author Louis van Alphen
At 09:38 2001-08-28 -0400, you wrote:
> To loose 10 developers onto the database, each making changes as
>they need is scary. Planning and coordination are key.

I have to say that I agree. We are doing things in a different way now.

> We
>have always assigned a developer to the role of "development DBA". They
>maintain the scripts which build the test databases (and ultimately the
>production DB). They coordinate all meta data changes. They control
>field/domain/table naming to ensure consistency.

Agreed. This is how we are gonig to do it now.

>We also build our databases from SQL text scripts which are kept under
>version control. That way we can track changes better.
>We also have SQL text scripts which populate the database with test data.
>That way we can start with a predictable setup when testing.

Very good point. This makes for repeatable DB builds and migrations/populations

Thanks for the tips