Installation and deployment
Version 7.x > Installation and deployment > Can I use DB Script for the Changes that are being made using CMS Admin section? View modes: 
User avatar
Member
Member
ashish.diwaker-technousa - 12/26/2013 9:24:18 AM
   
Can I use DB Script for the Changes that are being made using CMS Admin section?
Hi,

I am actually working on a website built using Kentico CMS. There are basically maintenance works done here. Therefore, whatever is modified on my Development environment, is repeated on each environment. And most of the times the Steps are repeated on 3 to 4 times depending on the different Environments we use for website.

Whenever changes like
1) modifying Transformation (used for any particular Document type),
2) modifying Settings for any Blog/Blogpost/Event/Other similar Page Types.
3) Other general modifications.

They usually takes a lots of time to get implemented on Live Website. Can you suggest me how can I reduce this overhead to repeat steps on different environments.

Should I create DB Script for the changes wherever possible, I don't know If it could miss ant important change that I am not aware of and is being done by CMS internally.

Thanks
Ashish

User avatar
Kentico Legend
Kentico Legend
Brenden Kehren - 12/26/2013 9:42:47 AM
   
RE:Can I use DB Script for the Changes that are being made using CMS Admin section?
I'd highly recommend against running any t-sql script on the website's database. There are too many interrelated dependencies that I'm positive will be messed up.

You'd be better to setup Content Staging as long as you have a license for it. This will allow you to synchronize changes (content, object, data, etc.) from one server to another by simply clicking a button.