Currently we are working with Sourcegear Vault for our source control. This is working great for us at the moment.
But our team is getting larger and we are starting to look at newer programs to handle our needs. One of those programs uses git as source control.
This seems to be a good source control, but I see a problem for us using it and that is with database changes.

In our current situation we have one package in which we write our database changes that need to happen. These changes happen sequentially and can only happen by one person at a time.
Only one person can add a new zone or index to a table at one time.
We also work on one shared development database and shared int files on a server.

This way nobody can create the same new field/index twice.

How does this work in git with working with branches? If one person creates a branch and is adding zones or indexes, then this happens locally I believe.
If another person is creating a different index on the same table, how does this eventually get merged together in the correct order.
Because both persons could have created an index 5, but with different zones in it.


How does one handle database changes with Dataflex in Git?