...
To make changes to this master SVN project easier, the project also manages a master database schema (OLEDBA). This schema is exported nightly to the ole-cfg-dbs/development path in SVN. This allows changes to be made to the master schema using normal database tools rather than requiring the "DBA" to edit the files in SVN. Any changes made to the schema during the day will be exported by the DB-Export-OLEDBA job in Hudson every night. For this reason, never update the files in the ole-cfg-dbs/development path directly, as they will be overwritten by the state of the OLEDBA schema the next night.
Then, using this SVN project, any of the development or testing databases can be refreshed from that stored definition. In fact, on a daily basis, the OLECI (for unit testing), OLELOCAL (for developers without a local database), and OLEDEV (for the http://dev.ole.kuali.org:8080/ole-dev/ instance) are deleted and restored from this project.
The additional complication to this is that there are actually three components to the full refresh process as will be discussed below.
ole-cfg-dbs Project Structure
| Note |
|---|
|
Document TODO Notes
| Note |
|---|
|