Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • mmmoustache 50 posts 79 karma points
    May 25, 2012 @ 13:57
    mmmoustache
    0

    Pulling data from a pre-existing mySQL database into an Umbraco site

    Hi Everyone,

    I'm migrating/re-building an old php site to an Umbraco site and want to use parts of the old database on the new one, specifically a section that consists of about 4000 user-submitted entries, including name, an image, among other details. How can I pull information from the old db into the new Umbraco site? Specifically, I'd like to use Razor to list all of these entries into a new page, and even better: is there any way I can integrate them as Umbraco nodes? I'm new to mySQL so I've no idea if this sounds incredibly easy or if it's impossible.

    Kind Regards,
    mmmoustache

    Copy Link
  • Richard Soeteman 4046 posts 12899 karma points MVP 2x
    May 25, 2012 @ 15:21
    Richard Soeteman
    0

    Hi,

    If you can convert the Mysql database to SqlServer, using import data into sql server you can use CMSImport to import the data into your Umbraco environment. CMSImport  is free to use for 500 nodes. 

    Hope this helps,

    Richard

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft