After initally setting up my instance of BlogEngine.NET and creating a few posts etc I decided I wanted to use SQL instead.
Doing a few google searches resulted in finding this post http://nyveldt.com/blog/page/BlogEngineNET-Provider-Migration . I followed the instructions and completed the migration with all the information I was expecting from this tool now in my database.
However, I had to run this on all Blogs residing in BlogEngine.NET and it did not migrate files I had uploaded. Therefore i decided to start writing a tool in C# which would hopefully do a complete migration. I am only in the very early stages of writing this please stay tuned for more information.
Update 11/10/2015 00:13: Have just been messing around with the front end so far and the controls it will use. This is what i have so far:
Here is the main front end where you can enter your IIS Web site location, server path and the provider from and to selections. The IIS Server details uses to FolderDialog control and the SQL Sever details uses the Microsoft.Data.ConnectionUI.Dialog. More to follow.