Hi, I dont know if this is possible but we are in the process of moving a customers site from an external hosts CMS to our local government hosting and DNN.
The client wanted to keep their existing look and to cut a long story short I have finally overcame their reservations and persuaded them to move from their current look to a mobile responsive skin.

Now, I have a number of pages already built using their current design and I would like to be able to move the pages to the new responsive skin and containers in SQL, I have some SQL from Chris Hammond which will let me update the skins and containers no problem.
What I would like some help with:
 I also want to assign custom templates to these pages, can I and if so where?.

Can I also change the pane names that the content are currently using to the new responsive skin panes.

Well, I tried updating the skin of a page via sql,
Update Tabs set skinsrc = '[G]Skins/myskinHome.ascx' where TabID = 105
(I copied an existing skin reference).

And although it worked it would not refresh (despite shutting down the browser and opening again, not until I logged into the edit page apearance where the new skin was actually referenced and clicked update.

Similar position for a content pane update.

Is there a way to force a refresh for all pages in one go?.

I tried this via sql management studio, and running the site sql tool .

Any advice

Thanks Richard.
That worked a treat, I was able to change skins and containers and rename the content panes and after a restart all was fine.
Test this on our dev system so no danger of anything going wrong.

In case anyone wants to do the same here is the SQL I used.

/*select all child tabs with parent name*/
SELECT a.tabID, a.title,a.SkinSrc,a.ContainerSrc, a.IsVisible,COALESCE(b.tabName,'-') AS 'ParentName'
FROM Tabs AS a LEFT JOIN Tabs AS b on a.parentID = b.tabID
where a.IsDeleted =0
-- To limit a selection
AND a.tabID in('101','105')


/* see skins and containers by tab *****************************************************
*************************************************************************************************/
select tabID,tabname title,SkinSrc,ContainerSrc from Tabs where PortalID=0 AND IsDeleted =0
and tabID in('101','105')
--update
Update Tabs set skinsrc = '[G]Skins/SkinFolderName/SkinName.ascx'where TabID = 105



/* see Panes by TabModuleID*****************************************************
*************************************************************************************************/
--
select TabModuleID, TabID,PaneName,ModuleTitle from TabModules where tabID in('101','105')

Update TabModules set PaneName = 'NewPaneName'where TabModuleID=195