I read Rational RTC help on how to migrate Oracle database.

Unfortunatelly it does not explain how to migrate data from Oracle Database for RTC 2.0 to Oracle Database for RTC 3.0.1. Is there manual for that? Any help will be greatly appreciated.

Thanks,
Alex K

Hi

You may be looking in the wrong place - check the documentation for upgrading from RTC v2 to v3. Moving to a new version of RTC (but staying on the same database type) is an upgrade, not a migration.

Let us know via the forum if you don't find the upgrade information.

regards
anthony

Hi there -

The repotools-jazz is created during the 3.0.1 install if, during the install, you indicate that you are upgrading from RTC 2 and therefore need to maintain the jazz context root. Otherwise, a repotools-ccm is installed by default. The context root choice impacts other aspects of the install so it would not be enough to just rename the repotools-ccm file. It turns out to be easier to reinstall rather than try to make all these changes.

Also, there are a few decisions you will need to make as part of the RTC 2 to 3.0.1 upgrade. For example, do you want the JTS to be co-located on the same server as your RTC application? Even if you currently want them co-located, you may want to consider using a different virtual host name or alias for the Public URI you'll be establishing for the JTS at 3.0.1 so that you have the option of moving them to separate machines in the future. You can find info on this and other planning aspects here:
http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=/com.ibm.jazz.install.doc/topics/c_upgrade_consideration.html

Once you've done all your planning and created the JTS and data warehouse databases, there are upgrade wrapper scripts that can walk you through the repotools cmds that will do the file merging, user synchronization, etc. These scripts are described here:
http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=/com.ibm.jazz.install.doc/topics/t_upgrade_rtc2_auto_scripts.html

Hope this helps!

Sincerely,
Gail

How long did your Data Warehouse data collection take once the upgrade was complete? We are also using oracle, and the data collection has been running for days

Mike

Hi there -

The repotools-jazz is created during the 3.0.1 install if, during the install, you indicate that you are upgrading from RTC 2 and therefore need to maintain the jazz context root. Otherwise, a repotools-ccm is installed by default. The context root choice impacts other aspects of the install so it would not be enough to just rename the repotools-ccm file. It turns out to be easier to reinstall rather than try to make all these changes.

Also, there are a few decisions you will need to make as part of the RTC 2 to 3.0.1 upgrade. For example, do you want the JTS to be co-located on the same server as your RTC application? Even if you currently want them co-located, you may want to consider using a different virtual host name or alias for the Public URI you'll be establishing for the JTS at 3.0.1 so that you have the option of moving them to separate machines in the future. You can find info on this and other planning aspects here:
http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=/com.ibm.jazz.install.doc/topics/c_upgrade_consideration.html

Once you've done all your planning and created the JTS and data warehouse databases, there are upgrade wrapper scripts that can walk you through the repotools cmds that will do the file merging, user synchronization, etc. These scripts are described here:
http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0m1/index.jsp?topic=/com.ibm.jazz.install.doc/topics/t_upgrade_rtc2_auto_scripts.html

Hope this helps!

Sincerely,
Gail

Thanks Guys,

I finally figure it all out. I migrated data, and it looks ok, at least data wise. I put another topic here on the issue I have now. See Syntax Error topic from today ;)...