I have an asp.net core 6.0 application, which is using PostgreSQL. The application has 2 database schemas, and the second one is Hangfire. Needless to say, the first database is bitemporal. I want to migrate both databases from PostgreSQL to MsSQL. I want to migrate all the store procedures, types, and functions, together with the existing data. So far I’ve managed to migrate the first database, and I’ve also created many integration tests. Hangfire database does not have store procedures, types, and functions, so only the existing data will be migrated.
My question is: Is there any specific way to migrate the Hangfire database from PostgreSQL to MSSQL? If someone has a tutorial in mind, it will be very helpful.