Db deploy: SQL delta scripts Vs ActiveRecord Migrations pattern

<< Tool di automazione Vs tool di suppporto | Home | 3 myths about software development >>

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

Chi gli ha già provati ?

Print | posted @ mercoledì 16 settembre 2009 20.02

Comments on this entry:

# re: Db deploy: SQL delta scripts Vs ActiveRecord Migrations pattern

by Gian Marco at 16/09/2009 21.26

Per un progetto in sviluppo stiamo usando questo:

http://code.google.com/p/migratordotnet/

Rispetto a dbdeploy, le migrazioni si scrivono in c# utilizzando un DSL indipendente dal DBMS. Questo rende le migration portabili e piu comode da sviluppare, ma a mio parere rende piu scomodo diagnosticare eventuali problemi di script.