How to export change set archive from RTC

There is an export you can perform using the repotools command line tool. Here is a pointer to some help doc on the topic:

http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/index.jsp?topic=/com.ibm.jazz.install.doc/topics/r_repotools_export.html

However, this is really just a backup of the entire database (i.e. SCM, work items, etc) and is not manipulatable in the same way the svn dump file is.

Tried the export. Got the error below.

The only thing running on the machine was the export and the only thing accessing the DB was the export. Thoughts?

<pre>
C:\rtc_inst\jazz\server&gt;repotools.bat -export toFile=test-export.tar
Repo Tools
Jazz Foundation - Jazz Team Server, Version 1.0.0.2 iFix 3 (I20100602-1000)
Rational Team Concert, Version 2.0.0.2 iFix 3 (I20100602-1000)

Rational Jazz Team Server - Express-C
CRJAZ1363I Loading configuration from &quot;file:conf/jazz/teamserver.properties&quot;.
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //localhost:50000/jazz2:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/NT
Db Product Version: SQL09070
Db URL: jdbc:db2://localhost:50000/jazz2
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192I: Fulltext Index Location: C:\rtc_inst\jazz\server\workitemindex\fulltext_index
CRJAZ8190E: The fulltext index location property (indexLocation) should point to an absolute directory but is currently set to 'c:workitemindex'
The user &quot;ADMIN&quot; has logged in to the database &quot;//localhost:50000/jazz2:user=xxxxxxxx;password=xxxxxxxx;&quot;.
Exporting the data from the database &quot;//localhost:50000/jazz2:user=xxxxxxxx;password=xxxxxxxx;&quot; to the file &quot;test-export.tar&quot;.
Using encoding &quot;windows-1252&quot;
CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts can occur during periods of high server traffic. You should retry your operation, and contact your server administrator if the problem
persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: DELETE FROM SCM.CONFIGURATION_SELECTIONS WHERE JZ_PARENT_ID = ?
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=3.53.70
SQL State: 57011
Error Code: -964

The user &quot;ADMIN&quot; has logged out of the database &quot;//localhost:50000/jazz2:user=xxxxxxxx;password=xxxxxxxx;&quot;.
CRJAZ1318I A retryable database error occurred. Database deadlocks and timeouts can occur during periods of high server traffic. You should retry your operation, and contact your server administrator if the problem
persists.
CRJAZ0265I The virtual storage or database resource is not available.
SQL: DELETE FROM SCM.CONFIGURATION_SELECTIONS WHERE JZ_PARENT_ID = ?
SQL Exception #1
SQL Message: DB2 SQL Error: SQLCODE=-964, SQLSTATE=57011, SQLERRMC=null, DRIVER=3.53.70
SQL State: 57011
Error Code: -964
</pre>

Was your server running at the time? The export can only be performed if the server has been shut down.

Was your server running at the time? The export can only be performed if the server has been shut down.

Server wasn't running. Also I am sure that nothing else was accessing DB2 at the time.

There is an export you can perform using the repotools command line tool. Here is a pointer to some help doc on the topic:

http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/index.jsp?topic=/com.ibm.jazz.install.doc/topics/r_repotools_export.html

However, this is really just a backup of the entire database (i.e. SCM, work items, etc) and is not manipulatable in the same way the svn dump file is.

Michael,
I have one team asking to move their code and work items from their RTC erver to ours.

Can I just run repottols export on their server and then take the output tar file and run repotools import to get it done?

What is exported: the whole repository on their RTC server?
We just want one project area and all SCM and work items data related if possible?

You cannot currently export or import a single project area. That is
the much anticipated &quot;project move&quot; operation.

Cheers,
Geoff

On 2/10/2011 10:38 AM, ghu wrote:

mvalentawrote:
There is an export you can perform using the repotools command line
tool. Here is a pointer to some help doc on the topic:


http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/index.jsp?topic=/com.ibm.jazz.install.doc/topics/r_repotools_export.html

However, this is really just a backup of the entire database (i.e.
SCM, work items, etc) and is not manipulatable in the same way the
svn dump file is.

Michael,
I have one team asking to move their code and work items from their
RTC erver to ours.

Can I just run repottols export on their server and then take the
output tar file and run repotools import to get it done?

What is exported: the whole repository on their RTC server?
We just want one project area and all SCM and work items data related
if possible?

You cannot currently export or import a single project area. That is
the much anticipated &quot;project move&quot; operation.

Cheers,
Geoff

Thanks, Geoff,

In that case, what is going to happen if I import the tar file created by repotool export on another server? Will it merge the imported repository into the existing one or it will create a seperate one? Are we allowed to have multiple repository on the same server?

You can have multiple repositories on the same physical machine, but I
believe you will have to run separate RTC servers with distinct port
numbers for them. Perhaps someone on the forum could comment on
whether that has changed in RTC-3.0 ... i.e. can you run multiple CCM
repositories under a single RTC server? (I don't think so, but I could
be wrong :-).

In RTC-3.0, you can use a common JTS for multiple RTC (CCM)
repositories, but that's a different question.

Cheers,
Geoff

On 2/11/2011 9:53 AM, ghu wrote:

gmclemmwrote:
You cannot currently export or import a single project area. That
is
the much anticipated &quot;project move&quot; operation.

Cheers,
Geoff



Thanks, Geoff,

In that case, what is going to happen if I import the tar file created
by repotool export on another server? Will it merge the imported
repository into the existing one or it will create a seperate one?
Are we allowed to have multiple repository on the same server?

In RTC 3.0, the SCM component supports distributed so you can now replicate your source code artifacts from one server to another so transferring the SCM artifacts would be fairly straight forward.

The problem is the work items. For work items, you would need to export them from the source server and import them into the target. However, the work item numbers and unique identifiers would change so any change set to work item links you had would no longer be valid. It is possible to write a tool that would translate the links but this requires some in-depth knowledge on the shape of the links. This was done for the RTCz project but I'm not sure it is practical for others to consume.