Adding tables to the Umbraco database Options
Adz
Posted: Thursday, August 28, 2008 9:31:07 PM

Rank: Aficionado

Joined: 6/5/2008
Posts: 145
Location: United Kingdom
Guys

I need to add my own table to an Umbraco based system.
My question is really about best practice:

Is it OK to add a table to the same database that Umbraco uses?

Or, should I create a separate database for my table?

Thanks in advance for your advice!




Adz

Adam Perry (blog, twitter), developing Umbraco based websites and applications for ConnectDigital.
Dirk
Posted: Thursday, August 28, 2008 10:00:57 PM

Rank: Addict

Joined: 9/27/2007
Posts: 977
Location: Belgium
Hi Adam,

What data should go in there? Site specific data? If so, I would defenitely integrate your own tables in umbraco's default install, otherwise...

I guess you get my point!

Let us know what solution you're going for!

Greetz,
/Dirk




level 1 certified - umbraco blog at netaddicts.be - working on an integrated forum4umbraco
jaygreasley
Posted: Thursday, August 28, 2008 11:13:21 PM

Rank: Devotee

Joined: 6/6/2008
Posts: 75
Location: Barling Magna
One thing to bear in mind is if you intend to use Courier, although I imagine Courier would only look for Umbraco tables. Also, consider if there was a schema change in the Umbraco core. It depends how these would get rolled out. If may be easier to have your custom tables in a separate db so they are unaffected by schema upgrades.
One last thing, if these tables are for generic .net controls it would be easier to keep it separate.
Hope this helps promote thoughts/discussion....
Users browsing this topic
Guest


You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.