Continuous Integration and the Automated Database Update Process

[article]

       <if test="${file::exists(sql.syncfilename)}" >

                      <property name="HasSQLScriptRun" value="true" />

       </if>

</target>

Runpostsql
Data changes that are applied after schema updates—which are approximately 99 percent of all data updates—are applied to the target database in this area. These data changes are checked into the \Post-deploy folder of the database SVNrepository. The scripts are run in alphabetical order so sequencing can be done.

<target name="runpostsql" >

       <!-- run post-deploys -->

       <foreach item="File" property="sqlscriptname" >

              <in>

                      <items basedir="${sql.scriptsourcepath}">

                             <include name="**\Post**.sql" />   

                             <exclude name="**\Pre-**" />

                      </items>

              </in>

              <do failonerror="true">   

AgileConnection is one of the growing communities of the TechWell network.

Featuring fresh, insightful stories, TechWell.com is the place to go for what is happening in software development and delivery.  Join the conversation now!

Upcoming Events

Sep 22
Sep 24
Oct 12
Nov 09