Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Robert Stigsson 47 posts 158 karma points
    Sep 29, 2015 @ 12:09
    Robert Stigsson
    0

    Migrating media information

    Hi!

    If you manually want to migrate media information I found out that you need to:

    Once per item:

    INSERT INTO umbracoNodes VALUES (trashed, parentId, nodeUser, level, path, sortOrder, uniqueId, nodeObjectType, createDate)
    

    Once per item :

    INSERT INTO cmsContent VALUES (nodeId, contentType)
    

    Multiple time per item:

    INSERT INTO cmsPropertyData VALUES (contentNodeId, versionId, propertyTypeId, dataInt, dataDate, dataNvcarchar, dataNtext)
    

    And lastly once per item:

     INSERT INTO cmsContentVersion VALUES (contentId, versionId, versionDate)
    

    Now, this has not taken folders into consideration and there is nothing that scrapes an old database for images, but I wonder if there already exist a package for this, if you're on 7.2.8/7.3.0? (or maybe someone already went the SQL-way. Works either way)

  • David Peck 690 posts 1896 karma points c-trib
    Oct 05, 2015 @ 14:55
    David Peck
    0

    I don't know if it will do what you're after, but I assume you've checked out this? https://our.umbraco.org/projects/developer-tools/cmsimport/

  • 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.

Please Sign in or register to post replies