Is it ok to version control my production database

ofernandez

If it is a good practice how can I have a branch with the development DB and a different branch with the Production DB

Thanks 

Tianjiao_Li

Hi @ofernandez

We don't suggest version control production database. You should use SQL Compare and SQL Data Compare for updating production database, or SQL Change Automation for automating your database delivery. For more information, please visit https://www.red-gate.com/products/

ofernandez

Thank  you for your previous reply.

Does it affect the performance of the database?

Tianjiao_Li

@ofernandez

Yes, it will slow down your server and more dead logs will be generated over the time.