Hello, we have used Redis for the past couple of years. We have thousands of recurring processes running in background daily, and thousands of scheduled ones to be run in the future.
Due to constant scaling issues on the Redis service we use, we decided to attempt a migration to SQL Server. We plan on keeping Hangfire Pro for metrics and batch operations.
Checking search history I noticed many people with the same question unanswered, therefore I imagine there is no automagical way of migration DB providers.
So, my question is a little bit different: How would you approach this migration? I was thinking: is there a way of querying all scheduled jobs on Redis and re-scheduling them on SQL Server?