Forums (Obsolete)

Old Forums

Portal Engine Questions on portal engine and web parts.

Version 7.x > Portal Engine > Which tables are not part of content staging? For example ...

View modes:

Member

JAA - 1/10/2014 9:37:23 AM

Which tables are not part of content staging? For example ...

I would like to identify the tables within the DB which are not staged. For example, I know these site specific tables are not staged:

dbo.CMS_CssStylesheet
dbo.CMS_CssStylesheetSite
dbo.CMS_Site

Is there a list of tables that aren't considered for staging? Will this change dependent if you are in deployment mode?

Thanks

Kentico Legend

Brenden Kehren - 1/10/2014 5:51:32 PM

RE:Which tables are not part of content staging? For example ...

Sorry to keep on your messages.

Are you saying the CMS_CssStylesheetSite table is not staged? If so, that is not entirely true. Changes to the Site and Stylesheet objects are staged without a doubt. If a stylesheet is added to a site, then a record is written in the CMS_CssStylesheetSite table and the change is staged and synchronized. This means synchronization will write a record in the CMS_CssStylesheetSite table on the target server when synchronization happens.

Just something to throw out there, it might be worth the time and/or money to purchase the source code from Kentico or even some consulting time to learn their in's and out's of the staging module.

Member

kentico_edwardh - 1/10/2014 7:18:30 PM

RE:Which tables are not part of content staging? For example ...

Hello,

CSS Stylesheets are absolutely synced and will appear in the CMS Desk -> Tools -> Staging -> Objects tab as long as you have the Site Manager -> Settings -> your site -> Versioning & Synchronization -> Staging -> Log object changes option checked. You can also manually sync these items from the objects tab if you prefer. Please reference this link - http://devnet.kentico.com/docs/devguide/content_staging_what_can_be_synchronized.htm - to see what Content staging will and will not sync.

Best Regards,
Edward Hillard

Member

JAA - 1/15/2014 7:56:25 AM

RE:Which tables are not part of content staging? For example ...

kentico_edwardh wrote: Hello,

CSS Stylesheets are absolutely synced and will appear in the CMS Desk -> Tools -> Staging -> Objects tab as long as you have the Site Manager -> Settings -> your site -> Versioning & Synchronization -> Staging -> Log object changes option checked. You can also manually sync these items from the objects tab if you prefer. Please reference this link - http://devnet.kentico.com/docs/devguide/content_staging_what_can_be_synchronized.htm - to see what Content staging will and will not sync.

Best Regards,
Edward Hillard

Thanks for the follow-up. I missed on the CssStylesheet table, my bad.

That said, I dont see staging tasks for these actions:
- SiteManager->Sites, changing "Site CSS stylesheet"
- SiteManager->Sites, changing "Site description"

Thank you for the documentation link, I will go through it.


Member	kentico_edwardh - 1/15/2014 4:29:32 PM RE:Which tables are not part of content staging? For example ... Hello, You are correct. The information from the Sites General tab (like CSS stylesheet and Site description) are not synched by default, as these values are typically different across each server like DEV, QA, and Production. Best Regards, Edward Hillard

Top