Migrations

1. On the database project select schema compare
2. Set Source (what you want the database to look like) and the Target (the database you want to change).

Tips

• If there is a Non-Nullable? property, set a default value Ex. GO ALTER TABLE [dbo].[Roles] ADD [RoleTypeInt] SMALLINT NOT NULL DEFAULT 0;

Then set it back after the migration.

---

To load a copy of the live Core locally use http://sqlazuremw.codeplex.com/