database table names Cancel

1. mark gamache

   

   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

   

   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

   
   www.telerik.com | dnn.telerik.com | www.sharepointcontrols.com | www.sitefinity.com | www.mcmscontrols.com
3. mark gamache

   

   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

   

   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