Website Bindings

Dan Butcher

Vote:

Is anyone able to point me to the table where the "Manage website" data is stored?

Specifically if you go into the abckend of episerver > CMS > Admin > Config(tab) then Manage Websites.

I have bindings here for each of the brands we manager with their URLS, Host Name, Culture, Type & Scheme.

I'm looking to find these details in the database so taht we can write a script to change them. We are often pulling down databases from our different environments and need to manually change these in the UI each time to work on local environments which is quite time consuming. I want to create a small bit of TSQL to change these values to save us time but I can't find where they're stored.

Thanks in advance.

#252936

Apr 09, 2021 14:38

Ravindra S. Rathore

Vote:

Hi Dan,

Check for "tblHostDefinition" and "tblSiteDefinition" into your CMS database.

https://world.episerver.com/forum/developer-forum/-Episerver-75-CMS/Thread-Container/2014/5/SQL-script-to-change-SiteDefinitions/

https://marisks.net/2017/05/31/automating-episerver-website-configuration/

#252937

Edited, Apr 09, 2021 15:19

Dan Butcher - Apr 19, 2021 12:48

Thanks for this. I already did this but it didn't seem to work - having reset the Application pools and restarting the server seems it just took some time to propogate

Jon Williams

Vote:

Are there any plans to build this kind of thing into the Content Manager API? Changing configuration values in the database seems like a risky thing (not necessarily for this specific change, mind).

#254036

Apr 28, 2021 15:02

Quan Mai

Vote:

Why can't you use ISiteDefinitionRepository to handle the site/host definition in one of the IInitializationModule?

#254077

Apr 29, 2021 9:03