ItEr64S07DatabaseUpgrade
TWiki>
LibrePlan Web>ItEr64S07DatabaseUpgrade (20 Aug 2012, ManuelRego)EditAttach
| Story summary | Database upgrade |
| Iteration | ItEr64week47To48 |
| FEA | ItEr64S07DatabaseUpgrade |
| Story Lead | |
| Next Story | ItEr65S05DatabaseUpgradeItEr64S07 |
| Passed acceptance test | No |
Acceptance Criteria
Additional Specification Comments
Implementation Notes
After a review of different tools that make easy the process to maintain the database updated, it seems that LiquiBase has a lot of interesting features:
- Hibernate integration
- Maven plugin
- Custom refactorizations
Configured maven plugin for LiquiBase based on information at: http://www.liquibase.org/manual/maven
-- ManuelRego - 24 Nov 2010
We need to check how we could generate SQL sentences to be applied on a production database when LibrePlan is not deployed using Maven.
Fixed bug #37 renaming all tables and fields in order to avoid problems between MySQL and PostgreSQL.
Uploaded LiquiBase plugin configuration, after checking that it would be possible to generate a SQL from the change sets: http://www.liquibase.org/manual/sql_output
-- ManuelRego - 30 Nov 2010
Added documentation about how to use LiquiBase and database conventions at Documentation page.
-- ManuelRego - 01 Dec 2010
We need to work more in this issue as we have problems for people downloading for first time the project with an empty database. Please see next message at LiquiBase forum to understand the problem and possible solutions: http://liquibase.org/forum/index.php?topic=814.0
-- ManuelRego - 03 Dec 2010
Delay Causes
Final or Pending Considerations
%RPSHOWGITCOMMITS%
| Tasks | Est | Spent | To do | Risk | Reviewer | Developer | Task Name | Start Date | Est End Date | End Date |
|---|---|---|---|---|---|---|---|---|---|---|
| Task | 4 | 14.25 | 0 | Low | JavierMoran | ManuelRego | Assess database upgrade possibilities |
| User | Spent in XpTracker | Spent in phpReport | Ok? |
|---|---|---|---|
| ManuelRego | 14.25 | 0 |  |
| Total | 14.25 | 0 | |
Copyright (c) by the contributing authors. All material on this collaboration platform is the property of the contributing authors.