http://www.longacre-scm.com/wiki/ 2010-09-05T10:31:44-05:00 http://www.longacre-scm.com/wiki/ http://www.longacre-scm.com/wiki/lib/images/favicon.ico text/html 2008-05-21T09:25:33-05:00 http://www.longacre-scm.com/wiki/doku.php/database_cm/three_ways?rev=1211379933 There are three ways to do change or configuration management of a database. Two of them are “traditional,” and the third is LDM. Let's look at them all. SQL is by its nature a change language. The individual statements in SQL are mostly focused on changing an existing database. While you use CREATE TABLE at first, every subsequent update will use ALTER TABLE. Manipulating data is done with INSERT and UPDATE commands. To explicitly set the entire contents of a row is an elaborate form of …