Hello York,
How I could backup the UAT ILMT database (TEMADB) and restore it under PROD ILMT server with the same database name (TEMADB)?
Backup/restore of the ILMT database (TEMADB) can be done using SQL Server Management Studio (SSMS).
Please remember that ILMT database is not linked to ILMT instance itself...so, it's perfectly safe to move TEMADB from one ILMT instance to another as long as it's the same OS & ILMT version:
https://www.ibm.com/docs/en/license-metric-tool?topic=mbc-migrating-license-metric-tool-server-between-computers-same-operating-systems
As to different besclient IDs...
It's a job of computer reconciliation mode processing...to match the agents using Host name/IP address rather than besclient ID.
As long as BigFIx Client has the same Host name/IP address it should be perfectly mapped between UAT & PROD ILMT.
------------------------------
Thank you,
Oktawian
Oktawian Powązka, L3 Support
IBM License Metric Tool
------------------------------
Original Message:
Sent: Tue February 20, 2024 07:53 PM
From: York Ly
Subject: Migrating ILMT endpoints from from UAT ILMT environment to PROD ILMT environment.
Hi Oktawian, to clarify your feedback. How I could backup the UAT ILMT database (TEMADB) and restore it under PROD ILMT server with the same database name (TEMADB)?
Even with the REST API method, how does it know to reference back to the same server as the computer ID or besclient ID would be different after UAT servers registered to PROD ILMT environment?
------------------------------
York Ly
Original Message:
Sent: Sat February 17, 2024 03:29 AM
From: Oktawian Powązka
Subject: Migrating ILMT endpoints from from UAT ILMT environment to PROD ILMT environment.
Hello York,
The crucial question is if there is a connection between UAT ILMT & PROD ILMT environments (PROD ILMT -> UAT Bigfix) ?
If it is you can back up the database of the UAT ILMT server and restore it under the PROD ILMT server and enable the computer reconciliation mode.
In such case Software classification is preserved during the migration..
If there is no connection the partial migration be means of REST API would be the only solution...
------------------------------
Thank you,
Oktawian
Oktawian Powązka, L3 Support
IBM License Metric Tool
Original Message:
Sent: Fri February 16, 2024 02:13 PM
From: York Ly
Subject: Migrating ILMT endpoints from from UAT ILMT environment to PROD ILMT environment.
ILMT 9.2.33 on Windows
Good day folks, we have a plan to migrate up to 500 Windows servers from UAT ILMT environment to PROD ILMT environment. Since the software bundling has been done on these 500 UAT servers and migrating them over to PROD ILMT environment will have a new BigFIx Client ID as well. They will end up a complete set of new servers in PROD environment. So that is an issue. How do I also maintain/reserve all the software bundling done on these 500 servers after migrated to PROD? We don't want to re-do each one of them.
Any simple working solution to accomplish this task? Please advise.
Thanks.
------------------------------
York Ly
------------------------------