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.
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.
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
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
is working on a reply...