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 687 posts 1863 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/

Please Sign in or register to post replies

Write your reply to:

Draft