ALM DB migration

Question ID: 110398
0
0

Hello All,

We are using ALM in windows platform, we had 200+ projects in DB1, later ALM was connected to DB2 keeping DB1 live, so we had 200+ projects created in DB1 and 10+ projects created in DB2 

Now the plan is to decommission DB1 keeping only DB2 live, in this case what happens to DB1 projects which are live, do we have to point the dbid of DB1 to DB2? Please advise

Marked as spam
Posted by (Questions: 16, Answers: 9)
Asked on January 6, 2023 7:13 am
9 views
Answers (1)
0
Private answer

In order to limit confusion and possible shutting down of "old" DB server by uninformed DBA's, you should consolidate all project schemas/databases into the SAME DB server, if possible.

If you were using DB1 at the time this instance of ALM was installed, it very likely also has the Site Admin schema (sometimes named "qcsiteadmin_db") there and pointed to by the ALM service as it starts up ALM.

If you de-commission DB1, you should migrate your Site Admin schema (as well as all project schemas) to the newer DB2 (and run the stored procedure to "fix" the td user - if using SQL-server with SQL-auth).

You CAN re-point where ALM gets it's qcsiteadmin_db from to use DB2.

https://eyeontesting.com/answers/moved-db-to-a-new-db-in-alm-1253-and-not-having-issues-getting-site-admin-working-on-the-new-db/

https://eyeontesting.com/answers/everything-was-working-fine-after-a-db-server-chan/

 

Also, if you need to move the project schemas from DB1 to DB2, you follow the usual Remove/Edit DBID/Restore process.  Here, you need to edit the DBID for each project that was using DB1 to have the same DB server name and URL as one of the DBID's for a project using DB2.

Marked as spam
Posted by (Questions: 4, Answers: 501)
Answered on January 11, 2023 3:43 pm
EyeOnTesting