The development environment's database is the one that everyone in the team should download to work with. The production's database can be downloaded to our local environment in very specific occasions when we need bleeding edge fresh data and when we are aware of the security implications of using it.
By working with the development environment's database, we gain the following benefits:
The development environment's database might not need tables that are present in production, such as old migration tables.
Compromising data in the development environment can be sanitized after the database has been copied from production. Therefore, when developers download the development's database into their local environments, they get a safe database to work with.
Large tables containing data that is not needed for development can be trimmed down, thus reducing the size of the database, which helps for faster performance of the
sql-sync
command.E-mail...