16 Aug 2010
15 Jan 2015
Link to this post
I think that's a pretty straightforward question, but I didnt found a proper solution yet.
So, the situation is folowing - I have working production version of the Sitefinity based website, with it's specific content etc. Now i want to REPLACE one of controls in all pages which uses it.
I understand thats the're a couple of options:
1. Grab production environments DB, attach to dev version, manually update each page (very time consuming, no one will give me a production DB)
2. Use SiteSync (no one will give me a direct access to production DB)
Basically my only option is to create a script which will update Sitefinity DB. I just ran my own tests - I have set up 2 copies of Sitefinity DB in on of the copies I just replaced a control. After that I executed SQL data comparison, and WOW, just WOW. Red gate data comparer says that there 're tons of changes in sf_control_properties, sf_permissions, sf_object_data, sf_object_data_sf_permissions. In additions some columns contains binary data, which is pretty hard to read.
Is there any solutions to update production environment using scripts?
Thanks a lot!