On 04/01/2007 03:28 PM, Anoop kumar V wrote:
> Sql create statements need to be run using a compatible client.
> sqlplus for
> oracle, mysqlclient for mysql etc.. Here you just have a target as
> part of
> your routine build that also takes care of building / renewing your
> database
> with (or w/o) data.
>
This wouldn't change anyhow, you'd still need a client during the build
process. You're just automating the control of the client, which IMHO is
only a good thing in certain circumstances. I agree it can be useful,
but not in all cases.
> Plus a layer of abstraction such as a ant for everything development
> related
> allows you to integrate into system integration tools like cruise
> control /
> continuum etc.. So you automate most of the stuff: building your
> database,
> testing against code etc... The investment is marginal and only during
> the
> setup of these tools, but the gains are phenomenal. (just like the
> benefits
> realized with setting up cvs and all)
> http://www.martinfowler.com/articles/continuousIntegration.html
> http://www.zorched.net/2006/08/19/relentless-build-automation/ (scroll
> down
> to the database part)
>
I'll take a look at these articles, thank you.
>
> Not to digress - but I would advise (strongly) the author to consider
> svn
> instead of cvs (svn: subversion is the new cvs built fresh from bottom
> keeping in mind the deficiencies of cvs)
> http://subversion.tigris.org/
>
Agreed, my experience with Subversion has been a pleasurable one.
-Micah
