Migrating site from MariaDB to MS SQL 2012 I'm trying to migrate the site from a linux+mariadb platform to IIS+MS SQL platform. Could someone please tell me what is the best way to do this?

What I've done so far:


Installed a vanilla Drupal site on IIS server to ensure everything works.
Tried migrating the database with SQL Server Migration Assistant (SSMA): https://stackoverflow.com/a/13898291/3199478


It's a Drupal 8 site so the Migrate and Migrate D2D modules are useless.
I recommend giving this tool a try. I have used it in the past (to do MSSQL -> MySQL) to setup a datasource for a legacy migration. In your case, you don't need a migration, you just need the db to be in MSSQL format. This is a great litmus test that might save you hours and hours of time.

https://dbconvert.com/mysql/mssql/

It's reasonably priced and worth a shot. If it works fine, you'll move right along.