Db deploy: SQL delta scripts Vs ActiveRecord Migrations pattern

Tool: ToughtWorks DbDeploy.NET
- use ActiveRecord Migrations pattern
- You can use other approaches if you have an ORM and you haven't released to production yet.
- You shouldn't use this pattern When you have a huge legacy database
- reference: http://www.dbdeploy.net/
Tool: Dbdeploy
- use SQL delta scripts
- for developers or DBAs who want to evolve their database design - or refactor their database
- to build development, QA, UAT (User Acceptance Testing) and production environments
- reference: http://dbdeploy.com/ and http://dbdeploy.com/wp-content/uploads/2007/05/taking-control-of-your-database-development.pdf