[closed] Migrating from derby to DB2
Xiang Dong Hu (76●2)
| asked Feb 11 '08, 8:15 a.m.
JAZZ DEVELOPER closed Jun 19 '23, 5:14 a.m. by Krzysztof Kaźmierczyk (7.5k●4●80●103)
In a typical scenario, a small team start trying Jazz with the default
deployment (Derby database, Tomcat). Someday in the future, more users/projects would like to use Jazz as the team platform and the team would like to migrate to use DB2 instead of the default Derby. My question is, in this case, is it feasible to export the existing data from the Derby DB and import to the DB2? Can the repotools accomplish this? |
The question has been closed for the following reason: "This is the question from 0.6beta version. There has been changed a lot regarding migrating database and making a backup. Please read the latest documentation for more details about that." by krzysztofkazmierczyk Jun 19 '23, 5:14 a.m.
4 answers
Yes, it really is that simple. The TAR file created by repotools' -export command is independent of the database implementation. Of course, once you've exported your data you'll need to update your teamserver.properties to use DB2 before performing the import using repotools' -import command. I hope this helps.
|
Thanks for the info! This is exactly what I was expecting, :-)
|
Can I use this export also to make a backup of a project area? And can I - after data loss - import this backup into a new installation of the jazz server?
|
Please read the following part of the Jazz Team Server Setup Guide:
https://jazz.net/downloads/DownloadDocument.jsp?href=betas/data/0.6Beta2a/server-install/index.html#repotools Here we say: "The Repository Tools Application is intended to be used for performing database migrations. The application is not intended to be used for performing a database backup. Consult your database vendor's documentation for how best perform a backup." While exporting your data to a TAR and then later importing it might sound like a way of backing up your data, please remember that exporting and importing using repotools is NOT INCREMENTAL. What this means is that when you perform an export, the entire contents of the Jazz database tables is exported to the TAR, and when you perform an import from a TAR the entire contents of any existing database tables is lost and replaced with the contents of the TAR. In fact, before we import data from a TAR we effectively run the repotools -createTables command first. Your best bet is to consult your database vendor's documentation for how best perform a backup. I hope this helps, Simon |