登台数据库困境(Staging database predicament)

 假设有3个数据库 
 
 
 
 生产 
 
 
 分期 
 
 
 开发 
 
 
 据我所知，Staging数据库需要与生产数据库同步但是， 
 
 在开发时，我们可以通过开发数据库和改变模式来做任何我们想做的事情。 现在鸡蛋和鸡蛋问题出现了。 
 
 要在Staging中测试，需要根据Dev数据库中所做的更改来更改Staging数据库模式。 但是Staging数据库需要与Production同步。 
 
 你们如何解决这个问题？ 

Suppose that there are 3 databases for
 
 
 
Production 
 
 
Staging 
 
 
Dev
 
 
As far as I know, Staging database need to be in sync with Production database But, 
 
When we are developing, we can do whatever we want with Dev database and change schema. Now here comes the Chicken & Egg problem.
 
To test in Staging, Staging database schema need to be changed according to changes made in Dev database. But the Staging database need to be in sync with Production.
 
How do you guys get around this problem?

原文：https://stackoverflow.com/questions/451519