Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Craig Cronin 304 posts 503 karma points
    Jul 27, 2015 @ 14:25
    Craig Cronin
    0

    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

    Copy Link
  • Clickfarm 77 posts 161 karma points
    Aug 11, 2015 @ 18:15
    Clickfarm
    0

    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.

    Copy Link
  • Craig Cronin 304 posts 503 karma points
    Aug 12, 2015 @ 07:31
    Craig Cronin
    0

    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 :)

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft