fluentmigrator | Fluent migrations framework for .NET | Database library

On my current project (.NET 5, ASP.NET Core), we're using FluentMigrator for running EF Core migrations which works flawlessly. We're in the process of setting up our infrastructure in Azure to communicate via Managed Identities and have set op a system assigned managed identity from our (web) app service to our SQL server.

We followed this guide to the point: https://docs.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-connect-msi?tabs=windowsclient%2Cdotnetcore

However, we get the following null pointer reference from FluentMigrator:

I have been working on a .Net Core project and I want to use MongoDb as a database implementation. I have created my entities that will be created as Collections. You can see the entities below.

When I start the project and if the database does not exist on the server, database and collections must be created according to entities that I have created. I should not create a database manually.

For Mssql, I am using FluentMigrator for this process. How can I handle it for MongoDb?

How does FluentMigrator know what migrations to execute / migrate when you start up the application?

Example: I got two migrations already performed (1 and 2). Now I create a third migration and give it an id of 3. When I launch my application, FluentMigrator will execute the migrations, but how does it know to skip the first two?

I have loaded a solution developed in a older visual studio version in my local visual studio 2017. There are many reference to external dlls. When I compile the solution I get error as below despite the fact that the dll's are available under the "packages" folder in the solution. The target framework of the projects in the solution are set to .NET Framework 4. I have .NET Framework 4.7.1 installed in my computer. I would appreciate some help on this.

Updated with project file

I am trying to open a solution using Visual studio 2019 and visual studio 2017. All the projects in the solution are loading except for one. When trying to load the unloaded project i get an error in the output window as

TakstMVC.csproj : error : The imported project "....build\MSBuild.Community.Tasks.targets" was not found. Confirm that the expression in the Import declaration "TakstMVC\.....build\MSBuild.Community.Tasks.targets" is correct, and that the file exists on disk. TakstMVC\FluentMigrator.targets

When i tried to open using VS 2017 i saw a migration report which said

TakstMVC.csproj: The application which this project type is based on was not found. Please try this link for further information: http://go.microsoft.com/fwlink/?LinkID=299083&projecttype=E3E379DF-F4C6-4180-9B81-6769533ABE47

Part of the .csproj of the project is as below:

I try to run dotnet tool install in Azure DevOps and test the tool.

Locally

When I connected to SQL Server, Fluent Migrator creates a Version Info table in the master database, but I create the database myself with a SQL script, then the app drops because it can't find the version info table.

What do I need to do for my script to run correctly?

C# code:

I have console app that uses FluentMigrator migrations, but now I need to implement user confirmation before actual migration process. I got into repo sources, found out about version loader and how to get unapplied list of migrations using IServiceProvider. But can't find a way yet to print SQL script of the migration that will be used in the MigrateUp(). I am using SQL Server package as well. Could anyone point a direction?

I have a multi-tenanted database. The tenant-specific data is stored inside it's own (PostgreSQL) schema.

I'd like to be able to use FluentMigrator to deploy new tenants as required. I've set up an example on GitHub where a HTTP post to an endpoint will deploy a schema. However deploys it to the public schema by default. I'd like to be able to specify the schema to deploy to.

I.e.