Do new Kentico upgrades overwrite SQL Server tables that aren't made in the custom table UI?

Jerreck McWilliams asked on April 21, 2015 19:52

If I made a bunch of tables in my KenticoCMS DB instance using SSMS instead of the custom table UI, would a future upgrade to a new version of Kentico wipe out my tables? Would there be any other concerns about using SSMS to create and manage tables as opposed to the UI or the custom table API?

Recent Answers

Brenden Kehren answered on April 21, 2015 23:30

Any custom tables you add to the database will not be overwritten or dropped. Just make sure you give them a total different naming convention you can keep up with.

If you plan to use any of the API with those tables, I'd suggest using custom tables to store the data in. Only reason is it makes things easier to access and manage plus you get full functionality out of them. Plus you get the UI to manage your schema as well as the data. You can use the Kentico form controls to perform validation on your data entry and updates without writing any code.

You can create a custom table based on an existing table, which works pretty well.

You can also import the data using the import toolkit. I do believe this requires the structure of the custom table object to already be in place.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.