Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Steps to move from SQL 2008 to SQL 2012 on RTC 4.0.6

We're getting ready to move the databases and I want to make sure I am not missing any steps. One big question is do I need to go through the "server rename process" when only changing the DB server and not the App server?

run server.shutdown on app server
Copy databases to the new server
      All databases will be renamed - does this cause any issues?
Backup and edit the following files - update with new DB server and new DB names (plus new passwords if different):
      conf/jts/teamserver.properties
      conf/jazz/teamserver.properties
Rebuild indexes:
      repotools-jts.sh -rebuildTextIndices
      repotools-jts.sh -reindex
      repotools-jazz.sh -rebuildTextIndices
      repotools-jazz.sh -reindex
Remove temp files from:
      server/tomcat/temp/*
      server/tomcat/work
run server.startup

Am I missing anything? Is there a repotools command I should run to test the new DB setup? Unfortunately, since I can't actually test this on a different app server without running the Server Rename Process due to the change of the Production app server to the Test app server, I will be doing this in Production without a full test. Rollback plan is to restore backups of the teamserver.properties files and reindex.

0 votes



One answer

Permanent link
Mike, if SQL server does the upgrade of the DB for you, you don't need any repotools commands. You would otherwise use repotools export and import to migrate the database (e.g. if changing vendor or if there is no way to upgrade the data otherwise such as different architectures).
If you change the database server and/or name you have to make sure the database connection properties in the teamserver.properties files get fixed.

And I would suggest a full backup before you do all this.

0 votes

Comments

There is no need to rebuild any of the indexes, as long as the indexes don't get deleted.

Is this true even when DB server name and DB names are changing?

Your answer

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,117
× 37

Question asked: Feb 03 '15, 2:52 p.m.

Question was seen: 4,196 times

Last updated: Feb 04 '15, 12:41 p.m.

Confirmation Cancel Confirm