I'm looking to extend a new umbraco build with various custom sections which will require a number of custom tables etc.
What's best practice, should I create a separate database to store this information so that it can be destroyed easily or keep everything the the main umbraco db?
Not sure if it helps, but with my custom tables I tried putting them in their own schema but Umbraco will only look in the dbo schema. I ended up just having to mix them in with all the other tables in the dbo schema.
Thanks for the comments. I recently attended an umbraco meetup where the guy was talking about putting them into a separate table which meant it was a little safer when using entity framework and migrations etc.
I've always tried to keep in the same database really but its good to see what others think :)
Location of Custom Tables
I'm looking to extend a new umbraco build with various custom sections which will require a number of custom tables etc.
What's best practice, should I create a separate database to store this information so that it can be destroyed easily or keep everything the the main umbraco db?
Thanks
Not sure if it helps, but with my custom tables I tried putting them in their own schema but Umbraco will only look in the dbo schema. I ended up just having to mix them in with all the other tables in the dbo schema.
Hi matt,
Thanks for the comments. I recently attended an umbraco meetup where the guy was talking about putting them into a separate table which meant it was a little safer when using entity framework and migrations etc.
I've always tried to keep in the same database really but its good to see what others think :)
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.