I have a client with an old .Net site that used SQL Server. For lots of reasons they decided to switch to Wordpress. They had a bunch of news articles on that old site that they want turned into posts or custom post types on their new Wordpress site (the standard post is probably easier?)
I reached out to their hosting company and got a
.bak file of their database and through online research it seems that MySQL workbench is the best route to go as far as getting this file into a MySQL DB. This is where I'm getting stuck. I don't deal with databases a ton besides backing up Wordpress MySQL databases to move them during local to production development or changing url structures.
Do I need to upload this file to a server somewhere like my personal production site's server to make this migration happen?
My plan was copy the Wordpress site over to my localhost and migrate the SQL Server backup file to my local MAMP server somehow as a test to see if it works correctly. I see this question was sort've asked before but there wasn't a ton of dialogue on that so was hoping anyone with new ideas could help me out since I gave a little more context on my goal. I'm on a mac by the way.
There are 1745 articles with categories and subcategories that won't match the current configuration in the Wordpress database. I asked my server side engineer here at work and he said a possible option is to export the database to CSV and use a CSV to Wordpress plugin to import it. Does this sound like a possibly easier solution?