Revert from SQL back to XML

May 26, 2011 at 7:27 PM

I am thinking of converting my from SQL storage back to XML. How do I do this?

I'm thinking of doing this because I'm going to be making a bunch of changes and it seems like storing the data in XML would make it easier. The changes include moving to a new server, a new version of Windows, new version of SQL and upgrading BE from 1.45 to 2. 

May 26, 2011 at 11:23 PM

Can;t You export as BlogML format, then switch over to XML and reimport the exported file?

May 27, 2011 at 6:49 AM

EXHD's idea is good and should work.  There's also this BlogEngine.NET Data Migration tool.  It's a little dated, but probably still works.  Even if it needs a couple of adjustments, the basic tool/concept is pretty good.