Update of derby database possible?
Hello
For our development of RTC server side plugins we are running a local Derby/Jetty based RTC server.
After creating some test data there we would like to reuse the data from that database when upgrading the RTC server.
Can the same data migration scripts be used as well on the Derby DB?
Is there any way to export and import the data in a RTC version compatible/safe way?
Thank you
Marko
2 answers
See the documentation on repotools-app ( app will be jts, jazz, ccm, qm, etc ) depending on the Jazz Application.
Presumably, you will maintain the current URL to move to a production environment. General steps:
- Use repotools-app -export for all your apps
- Create databases on your new database management system
- Update new teamserver.properties to have the correct jdbc parameters
- use repotools-app -isServerRunning to verify successful connection to the new database. Adjust #3 as required
- use repotools-app -import to load the exported data into the new database
Comments
Let's say I want to move from 6.0.2 to 6.0.3.
Which version of the repotools-app shall I use for each of the steps?
The old version for step 1 and then the newer one for step 5.?
I think you'd have to import/export using the same version i.e. the current version. Then perform the upgrades in the new environment.
For all I know you can use the normal upgrade process for Derby. I used to use that for testing. I havent done it for a while though. One difference with Derby is that the DB is local to the install dir and you have to copy the DB (s) over to the new installed upgrade target to point the teamserver.properties to the right one.