Creating Rock Migrations

When your code is ready to check in and you're ready to include it in the database as well, here's a checklist to review and use.

Create the new migration class

1. Run the Dev Tools\Sql\CodeGen_PagesBlocksAttributesMigration.sql script. It will output stuff you'll want to use in your next step.
2. Run AddMigration [YOUR_MIGRATION_NAME]
3. Edit this skeleton migration and paste in the stuff from the MigrationUp output into your migration's Up() method and then the MigrationDown output into the Down() method. Pay particular attention to the order that things are deleted since you cannot delete many things unless any related items are first deleted.
4. REVIEW each item you just pasted. Not all of them are things you should include in your migration.
5. Manually add any other data items that were not already accounted for by the SQL script including:

• EntityTypes
• NoteTypes
• PageContext (if any of your blocks use Context you should double-check this one)

Test your new migration class

6. Replace your db name with a new database name into your RockContext connection string in your web.connectionStrings.config file.
7. Run Update-Database to see if it worked
8. Verify everything by running Rock (F5) and checking every detail of your stuff.
9. If it's not good return to step 3 in the previous section; otherwise proceed to next step.
10. Lastly, test your Down() migration by migrating back to the last migration that exists before your new migration. Use the Update-Database TargetMigration:[THE_PREVIOUS_ONE]. If that was successful, continue to the Commit/Push/Deploy section otherwise go back to step 3 in the previous section.

Commit/Push/Deploy

If everything looks good, you can commit your changes, merge (as needed) and push up to origin.