Well, if anyone is interested here is a successful sql-export command, now i just got to figure out how to make a proper import
string query = @"SELECT
dbo.umbracoNode.text AS [umbracoNode-text, dbo.umbracoNode.uniqueID AS [umbracoNode-uniqueID], dbo.umbracoNode.createDate AS [umbracoNode-createDate],
dbo.umbracoNode.sortOrder AS [umbracoNode-sortOrder], dbo.umbracoNode.path AS [umbracoNode-path], dbo.umbracoNode.level AS [umbracoNode-level],
dbo.umbracoNode.parentID AS [umbracoNode-parentID], dbo.umbracoNode.id AS [umbracoNode-id],
dbo.umbracoNode.trashed AS [umbracoNode-trashed]], dbo.cmsContentType.description AS [cmsContentType-description],
dbo.cmsContentType.alias AS [cmsContentType-alias], dbo.cmsDocument.versionId AS [cmsDocument-versionId],
dbo.cmsDocument.published AS [cmsDocument-published], dbo.cmsPropertyData.dataNtext AS [cmsPropertyData-dataNtext],
dbo.cmsPropertyData.dataNvarchar AS [cmsPropertyData-dataNvarchar], dbo.cmsPropertyData.dataDate AS [cmsPropertyData-dataDate],
dbo.cmsPropertyData.dataInt AS [cmsPropertyData-dataInt], dbo.cmsPropertyType.Alias AS [cmsPropertyType-Alias],
dbo.cmsPropertyType.Name AS [cmsPropertyType-Name], dbo.cmsTags.tag AS [cmsTags-tag]
FROM
dbo.cmsContent INNER JOIN
dbo.umbracoNode ON dbo.cmsContent.nodeId = dbo.umbracoNode.id INNER JOIN
dbo.cmsContentType ON dbo.cmsContent.contentType = dbo.cmsContentType.nodeId INNER JOIN
dbo.cmsTagRelationship ON dbo.umbracoNode.id = dbo.cmsTagRelationship.nodeId INNER JOIN
dbo.cmsTags ON dbo.cmsTagRelationship.tagId = dbo.cmsTags.id FULL OUTER JOIN
dbo.cmsPropertyData INNER JOIN
dbo.cmsDocument ON dbo.cmsPropertyData.versionId = dbo.cmsDocument.versionId INNER JOIN
dbo.cmsPropertyType ON dbo.cmsPropertyData.propertytypeid = dbo.cmsPropertyType.id ON dbo.umbracoNode.id = dbo.cmsDocument.nodeId
WHERE
(dbo.cmsDocument.published = 1)
AND (dbo.cmsPropertyType.Alias = 'bodyText' OR dbo.cmsPropertyType.Alias = 'shorttext')";
As Richard is saying you can use CMSimport - I will recommend it since it will save you time and you don't re-invent the wheel. It's such a breeze to use. I'm really looking forward to the release of v2.0 :-)
Export / Import Umbraco Articles
Hi!
Is there a smart way to Export Umbraco articles from one installation and Import them to another?
/ Eric
Well, if anyone is interested here is a successful sql-export command, now i just got to figure out how to make a proper import
Hi Eric,
For importing data you can use CMSImport
Cheers,
Richard
Hi Eric
As Richard is saying you can use CMSimport - I will recommend it since it will save you time and you don't re-invent the wheel. It's such a breeze to use. I'm really looking forward to the release of v2.0 :-)
/Jan
Thanks Jan,
Also looking forward to the release of 2.0. You have to wait a little bit longer.... :)
Cheers,
Richard
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.
Continue discussion