| # | Step |
| 1 | Pull latest version of code from respository and build database locally from scripts. |
| 2 | Disable all jobs and make sure no jobs are running on deployment database server. |
| 3 | Create database backups on deployment database server. |
| 4 | Apply “Alter” scripts. |
| 5 | Compare local databases with environment databases using “SQL Compare”. |
| 6 | Re-enable all jobs. |
Comments