Forums (Obsolete)

Member

mcutter-global-id-group - 1/5/2009 9:28:18 AM

BizForm Table Name Refactor

I would like to rename the tables that bizforms are using.
The GUI doesn’t let me do this, but I assume I can do so in the DB as follows:
1) Create new_table and insert all records from current_table
2) Find where current_table is being referenced and change the reference to new_table
3) Delete current_table
Are these steps sufficient or is there anything else I need to do?
I need to know where the tableName is stored in a bizform record and assume you can tell me where to find this more quickly than I could discover it on my own.


Kentico Consulting	kentico_mirekr - 1/5/2009 12:51:04 PM RE:BizForm Table Name Refactor Hi, You can directly change the table name in database. Then you would need to find appropriate entry in CMS_Class table and change ClassTableName to your new table name. Best Regards, Miroslav Remias


Member	mcutter-global-id-group - 1/6/2009 11:21:31 AM RE:BizForm Table Name Refactor This almost works. It looks like tablenames are also embedded in cms_query. Are there any other places that tablenames would be embedded?


Kentico Developer	kentico_helenag - 1/9/2009 5:24:20 AM RE:BizForm Table Name Refactor Hi, please find the class ID of your BizForm class (in the CMS_Class table). Then find all records from CMS_Query with the ClassID of your value. Change their QueryText so that it corresponds with your new table name. Then restart the application in CMSSiteManager -> Administration -> System. Best regards, Helena Grulichova


Kentico Developer	kentico_helenag - 1/9/2009 5:26:43 AM RE:BizForm Table Name Refactor Hi, please find the class ID of your BizForm class. Then find all records from CMS_Query with the ClassID of your value. Change their QueryText so that it corresponds with your new table name. Then restart the application in CMSSiteManager -> Administration -> System. Best regards, Helena Grulichova


Member	scott_hancock-urmc.rochester - 10/18/2012 8:43:36 AM RE:BizForm Table Name Refactor Will these steps still work in v6? Thanks, Scott


Kentico Support	kentico_jurajo - 10/19/2012 2:13:03 AM RE:BizForm Table Name Refactor Hi, It is still the same approach. However, be sure you have backup of your DB or the data you are changing. Best regards, Juraj Ondrus