Copied to clipboard

Flag this post as spam?

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


  • Przemek Luczak 19 posts 30 karma points
    Apr 23, 2012 @ 19:49
    Przemek Luczak
    0

    Migrating Members: Production > Staging using DB Script

    Hi there,

    I have a problem with migrating members with the DB script I was using before and found here:

    http://forum.umbraco.org/yaf_postst4140_Migrating-members-from-stage-to-prod-with-the-db.aspx

    I used that script before without problems, can anyone advise what can be wrong based on the Debug message below?
    Many thanks
    P

    All seem to went fine except:

    (0 row(s) affected)
    ##################INSERT NEW [cmsContentVersion] EXP##################

    Umbraco version: umbraco v 4.7.0 (Assembly version: 1.0.4090.38017)

     

    Make temp table of new member nodes!
    reseed to new nodeIds do not conflict with existing
    Checking identity information: current identity value 'NULL', current column value '21912'.
    DBCC execution completed. If DBCC printed error messages, contact your system administrator.
    ##################Creates a list of node IDs to transfer with new node ids##################

    (1006 row(s) affected)
    ##################INSERT NEW NODES INTO STAGE##################

    (1006 row(s) affected)
    ##################INSERT NEW [contentType] INTO STAGE##################

    (1006 row(s) affected)
    ##################INSERT NEW [cmsMember] INTO STAGE##################

    (1006 row(s) affected)
    ##################INSERT NEW cmsMember2MemberGroup INTO STAGE##################

    (1006 row(s) affected)
    ##################INSERT NEW cmsPropertyData EXP##################

    (21126 row(s) affected)

    (1006 row(s) affected)
    ##################INSERT MISSING NULL [cmsContentVersion] EXP##################

    (0 row(s) affected)
    ##################INSERT NEW [cmsContentVersion] EXP##################

    (1006 row(s) affected)

  • Richard Soeteman 4049 posts 12922 karma points MVP 2x
    Apr 24, 2012 @ 06:14
    Richard Soeteman
    0

    Hi,

    What you could do is export the records from one environment using MemberExport and load them in your outher environment using CMSImport

    If you have less than 200 records to export it's free for Memberexport and if you have less than 500 records to import you can use CMSImport for free as well.

    Hope this helps,

    Richard

Please Sign in or register to post replies

Write your reply to:

Draft