Upgrading SQL Server database from 1.0 to 2.0
I'm migrating from RTC 1.0 to 2.0. I'm a little unclear on how to implement a 2.0 SQL Server database. I understand that I need to use repotools export and import to migrate the data, but I don't understand the exact sequence of commands to prepare a 2.0 database. I'm reading that I should use the command: CREATE DATABASE jazz, but I'm not sure if that applies if I already have an existing database. Could someone assist me in this, or point me to the documentation that may assist me? Thanks
|
3 answers
I'm migrating from RTC 1.0 to 2.0. I'm a little unclear on how to implement a 2.0 SQL Server database. I understand that I need to use repotools export and import to migrate the data, but I don't understand the exact sequence of commands to prepare a 2.0 database. I'm reading that I should use the command: CREATE DATABASE jazz, but I'm not sure if that applies if I already have an existing database. Could someone assist me in this, or point me to the documentation that may assist me? Thanks Hi Start with the online version of the help here: http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/index.jsp There is a section on installing and upgrading that should help. You will be creating a new database (and destroying the old one) - so that is why it is very important you do a repotools export on the old database, and make sure the export completes without any errors before you start moving to 2.0. anthony |
After consulting with my DBA, I still have questions about "destroying" the old database. He says he will delete the tables and indexes, but doesn't need to create a new database with "CREATE DATABASE jazz", or to create LOGIN jazzDBuser, as this is already done. Anyone have thoughts on this?
|
jazzman@unionmoose-dot-org.no-spam.invalid (vrcampbell) wrote in
news:h4kmtf$gda$1@localhost.localdomain: He says he will delete the That sounds good to me. The important are the tables. if the DB already exist, your DBA is correct. -- Christophe Elek Jazz L3 IBM Software Group - Rational |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.