Umbraco Database

cotton31 · 28 Mar 2012 at 11:14

I need a way to insert data into Umbraco's database.

Basically, we already have a bespoke CMS powering our site but want to migrate to Umbraco - I need to pull all the content out of the current CMS and insert it into Umbraco.

Having looked at the database, it doesn't look as though the content is stored in there :confused:

is that right?

Alternatively, if anyone has a better way of doing this, let me know!

cotton31 · 28 Mar 2012 at 14:07

Not very complex, I don't think constructing the XML string myself would be that difficult.

However, I don't seem to have any tables which are prefixed with cms!

I only have ones prefixed with Attribute and Node and one called Locale.

These all live in a database called umbraco - is there an additional database?

I'm a bit in the dark as I didn't install it!

cotton31 · 28 Mar 2012 at 14:16

Its V5, I definitely don't have any cms tables I'm logged into SQL Server Management Studio as SA and can only see the tables from my above post...

cotton31 · 28 Mar 2012 at 14:28

Right Ok, so the demo site doesn't have the tables our real site will have?

That would make sense as we haven't started moving our site yet, I was just investigating moving our data!

cotton31 · 28 Mar 2012 at 16:02

Hmmm right.

I think we might have made the wrong decision in going for v5!