More in this section

Forums / General Discussions / Location pages with a specific custom control, in the database

Location pages with a specific custom control, in the database

2 posts, 0 answered
  1. Richard
    Richard avatar
    49 posts
    Registered:
    13 Jul 2010
    19 Apr 2012
    Link to this post
    Hello all.

    I am currently in the process of migration to the latest version of Sitefinity and I believe I have a number of controls that are now redundant in my project. So for example, I have a control named "Deceased", using my SQL database, how would I find out how many pages reference this particular control?

    e.g.

    SELECT COUNT(DISTINCT Page) FROM tblPage
    WHERE ControlName = "Deceased"

    EDIT: Migrating from 3.7 (I've just noticed the databases are considerably different from 3.7 to 5 :) )

    Any help or suggestions greatly appreciated.

    Kind regards
  2. Andrei
    Andrei avatar
    553 posts
    Registered:
    27 Nov 2008
    20 Apr 2012
    Link to this post
    If you don't have loads and loads of pages, then you could rename the control for a few seconds and see which pages go wrong. otherwise use full-text search on teh database to find where the control is stored, get its ID and then full-text search again through the entire database which will show you in which other tables it appears. from there you can then work it out. so there are two very down and dirty ways of doing it. Hope it helps.
    Andrei
2 posts, 0 answered