Hello. We are currently unable to publish content. I thin k this is because we copied the databse to a dev site. My research tells me this is beacuse a column property "Identity" in the cmsPropertyData table needs chaning from FAlse to True.
Can anyone help me how to do this. I can see the property using SQL Server Management Studio but it's greyed out and doesn't let me change it.
Can anyone give me any direction? (Please?)
Thanks in advance.
PS_ should we be aware of anything else after copying this db? WHen I say copy we used the Studio Export wzard to create a new database.
I wouldn't recommend changing anyting to the db schema upon copying the db. I usually do the following when creating a "dev" site out of a production...:
- Backup db on production site and restore db on local/db machine's sql server
- Copy over complete /umbraco root folder, change connection strings to point to local db sql server/db
- Setup IIS (creating new site, pointing to umbraco root folder on local machine, configure host names, change dns settings in hosts file....)
- Browse to new site and you should be able to login using the same credentials as on original site
- Maybe perform a "republish" of the site using /umbraco/dialogs/republish.aspx?xml=true
That is exactly what I have just done and it works a treat. I tried backup and restoring all weekend only to be greeted with errors, so I tried an export.
Unable to publish content after copying database
Hello. We are currently unable to publish content. I thin k this is because we copied the databse to a dev site. My research tells me this is beacuse a column property "Identity" in the cmsPropertyData table needs chaning from FAlse to True.
Can anyone help me how to do this. I can see the property using SQL Server Management Studio but it's greyed out and doesn't let me change it.
Can anyone give me any direction? (Please?)
Thanks in advance.
PS_ should we be aware of anything else after copying this db? WHen I say copy we used the Studio Export wzard to create a new database.
Snelbert,
I wouldn't recommend changing anyting to the db schema upon copying the db. I usually do the following when creating a "dev" site out of a production...:
- Backup db on production site and restore db on local/db machine's sql server
- Copy over complete /umbraco root folder, change connection strings to point to local db sql server/db
- Setup IIS (creating new site, pointing to umbraco root folder on local machine, configure host names, change dns settings in hosts file....)
- Browse to new site and you should be able to login using the same credentials as on original site
- Maybe perform a "republish" of the site using /umbraco/dialogs/republish.aspx?xml=true
And off you go.
Cheers,
/Dirk
Dirk
That is exactly what I have just done and it works a treat. I tried backup and restoring all weekend only to be greeted with errors, so I tried an export.
No idea what was happening there!
Anyway, thank you very much for your reply.
Snelbert
is working on a reply...