v2.0 has significant schema changes, and hence a simple sql script could no longer serve as our primary upgrade mechanism. We are introducing a new upgrade system in 2.0 which will run in a couple of steps and upgrade the user's database. It has been an interesting exercise to come up with the upgrade script. Here are a few things we learned as we went through the process.
To simplify things, we split the upgrade process into multiple small steps. One step for each of the four major schema changes (contact, location, activity and custom), one step for the other minor schema changes...Read more