More in this section
Forums / Deployment / database table names

database table names

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
4 posts, 0 answered
  1. mark gamache
    mark gamache avatar
    34 posts
    Registered:
    23 Jun 2005
    21 Jun 2006
    Link to this post
    Is it possible to change the default database table names. I have to develop a site for a large IT dept that has naming standards for database tables.

    -mark
  2. Yavor
    Yavor avatar
    11 posts
    Registered:
    24 Sep 2012
    21 Jun 2006
    Link to this post
    Hi Mark,

    Yes, it is possible to change the default database table names.
    To do this you should rename all mentions of table names in the script which creates the DB object in your project's database (I guess it is SQL Server).
    Open the RadDesigner.sql file from the telerik\Sitefinity2.6\ProjectManager\Database folder and do the global replace for the tables you want to rename. When you create a Sitefinity project after that, you will create a DB with new table names.

    Note: There are embedded queries in some user controls and table names in them, so they should be changed too if you are going to use those user controls.

    Please let me know if you have additional questions.

    Regards,
    Yavor
    the telerik team
  3. mark gamache
    mark gamache avatar
    34 posts
    Registered:
    23 Jun 2005
    22 Jun 2006
    Link to this post
    I used your suggestion, but changing any of the tablel name results in the error:
    ********************************
    There's a problem setting the Database.
    Please, make sure that the SQL Server Database doesn't contain 'Sitefinity' tables & objects.
    SQL Error: Could not find stored procedure 'RadDesigner_StartProject'.

    *********************************
    This is during the 'Creating Project' phase. I was careful not to change the  'CREATE PROCEDURE' statements

    -mark

  4. mark gamache
    mark gamache avatar
    34 posts
    Registered:
    23 Jun 2005
    22 Jun 2006
    Link to this post
    UPADTE: I tried using notepad (not textpad) to do the global replace and it seemed to work ok...

    thanks,
    -mark
4 posts, 0 answered