Databases Reference
In-Depth Information
To get your local folders up to date with the version that is available in the
Subversion repository, you will need to perform an update. Right-click on the
folder you want to synchronize, and choose the
SVN Update
option (see
Figure 9
).
Removing a ile from your local folders will not remove the ile from the Subversion
repository. The next time you update your folder, the ile will be "missing" in the
eyes of Subversion, and will be placed back into your local folder. When you want
to remove a ile (or folder) from your local system as well as from the Subversion
repository, you will need to do a "Subversion delete". Right-click on the ile (or
folder) and select
TortoiseSVN | Delete
from the context menu. This will mark the
ile as "deleted", and the next time you commit your changes to the repository, the
ile will be deleted from the Subversion repository. This option is visible in
Figure 9
.
A
Sourceforge
project is started to combine the power of APEX
with XMLDB, which allows you to use the Oracle database as
your version control system. You can ind more information
about this project at
http://xace.sourceforge.net/
.
Deploying the database packages
When you keep all your iles in folders, it is very convenient to generate a script with
all the ilenames in a single SQL ile to be installed. That way, you will always know
which iles to call to install the database objects.
To generate the ile to install the package speciications, we use a
BAT
ile, which
looks similar to the following. We have similar iles for the other database objects.
@ECHO OFF
REM ===================================
REM == Prepare the Command Processor ==
REM ===================================
SETLOCAL ENABLEEXTENSIONS
SETLOCAL ENABLEDELAYEDEXPANSION
SETLOCAL
SET outputfile=%0
SET outputfile=%outputfile:~0,-4%.sql
set workdir=%~dp0
set currdir=%cd%
cd %workdir%
