Added by Dimitri Butko, last edited by Dimitri Butko on Oct 23, 2009  (view change)

Labels:

Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

While automatic update procedure is in development stage, following approach is recommended for manual Batavi update. The procedure is only relevant if you work with trunk checkout.

The basic procedure is shown on the image above.
More detailed on each step.

1. svn update

Assumes running `svn update` command in the command line (UNIX-like systems)
or using SVN interface, like tortoisesvn for Windows.
It can look like:

2. apply database changes

SQL changes which are to be applied to the software are presented in two folders.
DML - stays for Data Manipulation Language and usually contains set of INSERT and UPDATE statements (sql/dml/).
DDL - stays for Data Definition Language and usually contains set of ALTER and CREATE statements (sql/ddl).
You should apply both DDL and DML files which are added (marked as 'A' by SVN) in the update in the following order:

  • Sort all files by the date ascending (file date is part of its name)
  • Apply DDL files
  • Apply DML files

Example can be shown as follows:

No SQL errors should appear if everything is done in correct order

3. resolve conflicts if any

If you was editing Batavi source files - certain conflicts may appear.
Please, use generic conflicts resolving approaches used with SVN.
You may be interesting in the following link: http://svnbook.red-bean.com/en/1.5/svn.ref.svn.c.resolve.html