Where is the content stored in the Umbraco database?

Question

I inherited the database for the Umbraco website, I need to pull out the content so that it can be loaded into another CMS.

I restored the SQL Server database and I still can’t find where what is essentially “blog posts” will be stored.

What I want to do is something like:

SELECT * 
FROM blogposts

thanks

Answer 1

Unfortunately, this will not be so simple. Almost everything in umbraco has a view on the table umbracoNode.

Then, all the user property data that you have will be stored in these two tables: cmsPropertyDataand cmsPropertyType.

, , , :

SELECT TOP 1000 *
FROM cmsPropertyData pd
INNER JOIN cmsPropertyType pt
    ON pt.id = pd.propertytypeid
INNER JOIN umbracoNode n
    ON n.id = pd.contentNodeId
WHERE n.id = 1853

:

SELECT TOP 1000 *
FROM cmsPropertyData pd
INNER JOIN cmsPropertyType pt
    ON pt.id = pd.propertytypeid
INNER JOIN cmsContent c
    ON c.nodeId = pd.contentNodeId
INNER JOIN cmsContentType ct
    ON ct.nodeId = c.contentType
WHERE ct.alias = 'BlogPost'

, , node, cmsContentVersion, .

xml , . xml- App_Data\umbraco.config. xml.

fooobar.com/questions/915859/..., . Developer->Packages->Created packages . Package Contents Blog Post. , , . .