How to export data from umbraco CMS?

sql-server umbraco
Rajeev Prabhakaran Nair picture Rajeev Prabhakaran Nair · May 16, 2012 · Viewed 12.9k times · Source

I have a project which is using umbraco cms, ie. MSSQL (Now we are rebuilding the site in WordPress). Which i cannot understand the relations. It's difficult in Umbraco. So i would like to download/Export the content directly from Umbraco CMS. But in cms i don't find any option to export the bulk data. Is any other way to do this? Or if you can help me to find any free tools. Or any free tools that can do MSSQL to MySQL simply?

Thanks In Advance / Rajeev

Answer

Robby Cowell picture Robby Cowell · Mar 31, 2014

You can do this by creating a package. In the Developer section of Umbraco, expand the Packages node and right-click on 'Created packages' and click 'Create'. Click on the package and in the 'Package Contents' tab of the editor you can select a content node with an option to include all of its child nodes.

Umbraco content packaging

Complete the required fields in the 'Package Properties' tab. Once you've pressed 'Save & Publish' you will be given the option to download the package.

Download Umbraco package

You can now download your content in this package and install it on another instance of Umbraco by using the 'Install local package' option.

More detailed instructions for this approach are available here.

Related questions

How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More
OR is not supported with CASE Statement in SQL Server

The OR operator in the WHEN clause of a CASE statement is not supported. How can I do this? CASE ebv.db_no WHEN 22978 OR 23218 OR 23219 THEN 'WECS 9500' ELSE 'WECS 9520' END as wecs_system

Read More