mercredi 5 août 2015

Moving html data from mysql (wordpress) to sqlserver


I am upgrading a website to asp.net which have at least 100K posts in wordpress. I could not find any related topic for moving so i wanted to share my experience.

Big data is not a problem, however, some of wordpress tables have html data containing quotes (both single and double), &nbsp's, tab characters and so on. I have tried many ways for both exporting however, exporting to SQL file will not work for me (at least, i could not able to work with it, it causes so many troubles).



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire