Continuous Database Intergation .NET

RELEASED: DatabaseUpdater-1.0 (Mar 22, 2008)

Sat, 22 Mar 2008 00:44:21 GMT

The first version.

UPDATED RELEASE: DatabaseUpdater-1.0 (мар 22, 2008)

Sat, 22 Mar 2008 00:44:21 GMT

The first version.

UPDATED WIKI: Home

klalex — Sat, 22 Mar 2008 00:41:47 GMT

Database Updater is .NET application that helps you manage database updates and can be easily integrated with Cruise Control .NET.

For example,

<project name="ProjectName">
  ..
  <sourcecontrol type="svn">
  ...
  </sourcecontrol>
  <tasks>
    <exec>
      <executable>DatabaseUpdater.exe</executable>	
        <baseDirectory>[path to DatabaseUpdater installation folder]</baseDirectory>
        <buildArgs>-update</buildArgs>
        <buildTimeoutSeconds>360</buildTimeoutSeconds>
        <successExitCodes>0</successExitCodes>
    </exec>
    <nant>
    ...
    </nant>
  </tasks>
</project>

As you can see I specified only "0" as a success exit code. If Database Updater cannot execute one of the update scripts it will return exit code "2" and CCNET will stop deployment before the project will be compiled and published on the web.

To start using Database Updater you need to setup the database which means create a database schema and add information about the scripts that you probably already installed manually. Do not worry, Database Updater will do it for you. Just make a command:

DatabaseUpdater -setup -no_execute

"-setup" means adding database schema that needs Database Updater to work with database and "-no_execute" means add all scripts that you have without actually executing them.

But before this let's edit Database Updater configuration file - DatabaseUpdater.exe.config. Two things you should be considered - path to folder where you store update scripts (somewhere in the source control imported project folder) and connection string to the database.

After setupping Database Updater you can ask it to update the database by this command:

DatabaseUpdater -update

Or add Executable task in CCNET like I described above. The latest version of Database Updater with sources you can find here (release version placed in /bin/release folder inside the archive). Please notice also that Database Updater works with any database that .NET Framework supports. Enjoy the coding and let continuous integration do the other stuff!

UPDATED WIKI: Home

klalex — Sat, 22 Mar 2008 00:40:15 GMT

Database Updater is .NET application that helps you manage database updates and can be easily integrated with Cruise Control .NET.

For example,

<project name="ProjectName">
  ..
  <sourcecontrol type="svn">
  ...
  </sourcecontrol>
  <tasks>
    <exec>
      <executable>DatabaseUpdater.exe</executable>	
        <baseDirectory>[path to DatabaseUpdater installation folder]</baseDirectory>
        <buildArgs>-update</buildArgs>
        <buildTimeoutSeconds>360</buildTimeoutSeconds>
        <successExitCodes>0</successExitCodes>
    </exec>
    <nant>
    ...
    </nant>
  </tasks>
</project>

As you can see I specified only "0" as a success exit code. If Database Updater cannot execute one of the update scripts it will return exit code "2" and CCNET will stop deployment before the project will be compiled and published on the web.

To start using Database Updater you need to setup the database which means create a database table dbo.DatabaseUpdates that I described above and add information about the scripts that you probably already installed manually. Do not worry, Database Updater will do it for you. Just make a command:

DatabaseUpdater -setup -no_execute

"-setup" means adding database schema that needs Database Updater to work with database and "-no_execute" means add all scripts that you have without actually executing them.

But before this let's edit Database Updater configuration file - DatabaseUpdater.exe.config. Two things you should be considered - path to folder where you store update scripts (somewhere in the source control imported project folder) and connection string to the database.

After setupping Database Updater you can ask it to update the database by this command:

DatabaseUpdater -update

Or add Executable task in CCNET like I described above. The latest version of Database Updater with sources you can find here (release version placed in /bin/release folder inside the archive). Please notice also that Database Updater works with any database that .NET Framework supports. Enjoy the coding and let continuous integration do the other stuff!

UPDATED WIKI: Home

klalex — Sat, 22 Mar 2008 00:39:23 GMT

Database Updater is .NET application that helps you manage database updates and can be easily integrated with Cruise Control .NET.

For example,

<project name="ProjectName">
  ..
  <sourcecontrol type="svn">
  ...
  </sourcecontrol>
  <tasks>
    <exec>
      <executable>DatabaseUpdater.exe</executable>	
        <baseDirectory>[path to DatabaseUpdater installation folder]</baseDirectory>
        <buildArgs>-update</buildArgs>
        <buildTimeoutSeconds>360</buildTimeoutSeconds>
        <successExitCodes>0</successExitCodes>
    </exec>
    <nant>
    ...
    </nant>
  </tasks>
</project>

As you can see I specified only "0" as a success exit code. If Database Updater cannot execute one of the update scripts it will return exit code "2" and CCNET will stop deployment before the project will be compiled and published on the web.

To start using Database Updater you need to setup the database which means create a database table dbo.DatabaseUpdates that I described above and add information about the scripts that you probably already installed manually. Do not worry, Database Updater will do it for you. Just make a command:

<pre>
DatabaseUpdater -setup -no_execute
</pre>

"-setup" means adding database schema that needs Database Updater to work with database and "-no_execute" means add all scripts that you have without actually executing them.

But before this let's edit Database Updater configuration file - DatabaseUpdater.exe.config. Two things you should be considered - path to folder where you store update scripts (somewhere in the source control imported project folder) and connection string to the database.

After setupping Database Updater you can ask it to update the database by this command:

<pre>
DatabaseUpdater -update
</pre>

Or add Executable task in CCNET like I described above. The latest version of Database Updater with sources you can find here (release version placed in /bin/release folder inside the archive). Please notice also that Database Updater works with any database that .NET Framework supports. Enjoy the coding and let continuous integration do the other stuff!

UPDATED WIKI: Home

klalex — Sat, 22 Mar 2008 00:38:50 GMT

Database Updater is .NET application that helps you manage database updates and can be easily integrated with Cruise Control .NET.

For example,

<project name="ProjectName">
  ..
  <sourcecontrol type="svn">
  ...
  </sourcecontrol>
  <tasks>
    <exec>
      <executable>DatabaseUpdater.exe</executable>	
        <baseDirectory>[path to DatabaseUpdater]</baseDirectory>
        <buildArgs>-update</buildArgs>
        <buildTimeoutSeconds>360</buildTimeoutSeconds>
        <successExitCodes>0</successExitCodes>
    </exec>
    <nant>
    ...
    </nant>
  </tasks>
</project>

As you can see I specified only "0" as a success exit code. If Database Updater cannot execute one of the update scripts it will return exit code "2" and CCNET will stop deployment before the project will be compiled and published on the web.

To start using Database Updater you need to setup the database which means create a database table dbo.DatabaseUpdates that I described above and add information about the scripts that you probably already installed manually. Do not worry, Database Updater will do it for you. Just make a command:

<pre>
DatabaseUpdater -setup -no_execute
</pre>

"-setup" means adding database schema that needs Database Updater to work with database and "-no_execute" means add all scripts that you have without actually executing them.

But before this let's edit Database Updater configuration file - DatabaseUpdater.exe.config. Two things you should be considered - path to folder where you store update scripts (somewhere in the source control imported project folder) and connection string to the database.

After setupping Database Updater you can ask it to update the database by this command:

<pre>
DatabaseUpdater -update
</pre>

Or add Executable task in CCNET like I described above. The latest version of Database Updater with sources you can find here (release version placed in /bin/release folder inside the archive). Please notice also that Database Updater works with any database that .NET Framework supports. Enjoy the coding and let continuous integration do the other stuff!

UPDATED WIKI: Home

klalex — Sat, 22 Mar 2008 00:36:50 GMT

Database Updater is .NET application that helps you manage database updates and can be easily integrated with Cruise Control .NET.

For example,

&lt;project name="Philly2Night"&gt;
  ...
  &lt;sourcecontrol type="svn"&gt;
  ...
  &lt;/sourcecontrol&gt;
  &lt;tasks&gt;
    &lt;exec&gt;
      &lt;executable&gt;DatabaseUpdater.exe&lt;/executable&gt;
      &lt;baseDirectory&gt;[path to DatabaseUpdater]&lt;/baseDirectory&gt;
      &lt;buildArgs&gt;-update&lt;/buildArgs&gt;
      &lt;buildTimeoutSeconds&gt;360&lt;/buildTimeoutSeconds&gt;
      &lt;successExitCodes&gt;0&lt;/successExitCodes&gt;
    &lt;/exec&gt;
    &lt;nant&gt;
    ...
    &lt;/nant&gt;
  &lt;/tasks&gt;
&lt;/project&gt;

As you can see I specified only "0" as a success exit code. If Database Updater cannot execute one of the update scripts it will return exit code "2" and CCNET will stop deployment before the project will be compiled and published on the web.

To start using Database Updater you need to setup the database which means create a database table dbo.DatabaseUpdates that I described above and add information about the scripts that you probably already installed manually. Do not worry, Database Updater will do it for you. Just make a command:

<pre>
DatabaseUpdater -setup -no_execute
</pre>

"-setup" means adding database schema that needs Database Updater to work with database and "-no_execute" means add all scripts that you have without actually executing them.

But before this let's edit Database Updater configuration file - DatabaseUpdater.exe.config. Two things you should be considered - path to folder where you store update scripts (somewhere in the source control imported project folder) and connection string to the database.

After setupping Database Updater you can ask it to update the database by this command:

<pre>
DatabaseUpdater -update
</pre>

Or add Executable task in CCNET like I described above. The latest version of Database Updater with sources you can find here (release version placed in /bin/release folder inside the archive). Please notice also that Database Updater works with any database that .NET Framework supports. Enjoy the coding and let continuous integration do the other stuff!

UPDATED WIKI: Home

klalex — Sat, 22 Mar 2008 00:35:25 GMT

Database Updater is .NET application that helps you manage database updates and can be easily integrated with Cruise Control .NET.

For example,

<pre>
<project name="Philly2Night">
...
<sourcecontrol type="svn">
...
</sourcecontrol>
<tasks>
<exec>
<executable>DatabaseUpdater.exe</executable>
<baseDirectory>path to DatabaseUpdater</baseDirectory>
<buildArgs>-update</buildArgs>
<buildTimeoutSeconds>360</buildTimeoutSeconds>
<successExitCodes>0</successExitCodes>
</exec>
<nant>
...
</nant>
</tasks>
</project>
</pre>

As you can see I specified only "0" as a success exit code. If Database Updater cannot execute one of the update scripts it will return exit code "2" and CCNET will stop deployment before the project will be compiled and published on the web.

To start using Database Updater you need to setup the database which means create a database table dbo.DatabaseUpdates that I described above and add information about the scripts that you probably already installed manually. Do not worry, Database Updater will do it for you. Just make a command:

<pre>
DatabaseUpdater -setup -no_execute
</pre>

"-setup" means adding database schema that needs Database Updater to work with database and "-no_execute" means add all scripts that you have without actually executing them.

But before this let's edit Database Updater configuration file - DatabaseUpdater.exe.config. Two things you should be considered - path to folder where you store update scripts (somewhere in the source control imported project folder) and connection string to the database.

After setupping Database Updater you can ask it to update the database by this command:

<pre>
DatabaseUpdater -update
</pre>

Or add Executable task in CCNET like I described above. The latest version of Database Updater with sources you can find here (release version placed in /bin/release folder inside the archive). Please notice also that Database Updater works with any database that .NET Framework supports. Enjoy the coding and let continuous integration do the other stuff!

Source code checked in

klalex — Sat, 22 Mar 2008 00:31:56 GMT

The first version

UPDATED WIKI: Home

klalex — Sat, 22 Mar 2008 00:08:01 GMT

Database Updater is .NET application that helps you manage database updates and can be interated with Cruise Control .NET.

UPDATED WIKI: Home

klalex — Fri, 21 Mar 2008 23:01:47 GMT

Project Description