Database Development Organization

Question

Question about the database development project. The database already exists and is quite large (several TB).

• What do you use for version control in database development?
• How do you control concurrent changes in the data model with different teams.
• What is your approach to testing modules in database development.
• What is your attitude to confidential data if the database owners do not know what is sensitive? What is your approach to data obfuscation? What are your obfuscation methods?
• How do you work with a large database from several places?

Please answer one or more elements as you see fit. Each answer will be considered separately. Thank you very much!

EDIT: The relevant question with good answers on page 1 is here: How can you change the schema of your database?

Answer 1

For most of them, although the tools are not used, the general code development processes do:

• Maintain a development system separate from production with enough data to get useful performance indicators when testing a new model.
• This system has unit tests (SQL queries, commits, aborted atomic commits, etc.) written and executed against it prior to each version.
• There are official "releases"
• - - , .. , VCS , .
• ( , ..) , - .

Answer 2

4: " , , ? ?"

", " - . - ( ), .

, , .., .