Re: How to Update Live Website Database

Hi,

2009/1/7 venkat naidu <naidu545_at_yahoo.com>

> We fix bugs or add features in development environment which cause updates
> to
> database. When we update live website database, old data & new data are not
> in sync... How to update a database so that old data on live site is
> preserved and new modifications are also reflected .
>

Database modifications are not handled with file based version control. You
need to create update scripts that will modify the live database in the same
way as the development database was modified. That is not a trivial task, as
it often involves some sort of conversion of data currently stored in the
old format.

Use a proper database development tool that is capable of keeping track of
the structural changes made to a database, so you can generate the script to
use on the live database.

Subversion is not the right tool to do direct maintenance on databases. It
can be perfectly used to store the upgrade scripts you generate.

HTH

-- 
Regards,
Jean-Marc
--
      ___
 @@  // \\      "De Chelonian Mobile"
(_,\/ \_/ \     TortoiseSVN
  \ \_/_\_/>    The coolest Interface to (Sub)Version Control
  /_/   \_\     http://tortoisesvn.net