Just need a little clarity on this. We currently have a SQL install on a Windows box and and two 23.4 primaries. The second primary was only to get the the first primary to a point where it could do an upgrade. For some reason it wouldn't upgrade on it's own. Would it be easier to just remove the second primary, migrate and upgrade first primary, and then just add another primary back into the cluster after, instead of doing two migrations?
One of my questions is related to the DB. I have thought about going from MSSQL to the embedded database as we only have about 2000 devices. In the documentation, it says " If the primary server has the database role, the tool will automatically backup database also." Can I just restore it to the embedded database, or should I do database migration first? Or even after? I assume I still need to do that, but wasn't sure if it could be handled by the restore.
I have also never done a migration before, but I remember there being some concerns about certificates and such, and there was no way to move the CA holder, but that was years ago. Is this handled automatically by the migration?