Earlier I was creating database dump using mysqldump or phpmyadmin before create commit (Git). Yesterday I read Migration guide and It really very nice feature! But I don’t understand best way to adding dump to VCS.
For schema changes I will create migrations and add it in VCS, but should I adding full dump with data and schema (CREATE+INSERT queries)? I think,after a lot of many-many commits (e.g. 100+) applying all migrations for new developer can be a challenge due to the performance. And how to adding table data?
What is the best practice for a distribution software like CMS created under Yii? During development developers may change database many times. In release version aslo have all migrations, right? I think is aslo bad for end user, if he need applying many migrations? Maybe maybe there are tools for a merging many migrations?