As we know SQL Server support has been dropped at version 2022.2 on recorder component. What you have decided to do? Have anyone done a fork for recorder to keep it running?
What about the ones who have decided to migrate to PostgreSQL? Any tips?
The problem is I have another SQL Server database where I’m loading daily new states for longer history. That db got 70 million rows currently. So in my case it is not just spinning up new db instance.
I let HA to automatically generate new database. Cleared it once more and then manually went trough the internal counters on the tables to match my data warehouse history. However now I have lost the data for multiple months. Being too lazy to figure out how to do SSIS package from PostgreSQL to MSSQL. Before this it was easy to compare and input data from operative db to long term db.