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##################
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.
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)
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
is working on a reply...