using prefix in database? - Installing DNN Platform

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

1
2
3
4
5

Home

Getting Started

Installing DNN ...

using prefix in database?

7/17/2006 6:58 AM

Farhad Eftekhari

Joined: 6/15/2006

Posts: 4

using prefix in database?

i want to install more than one DNN in one databae and i like to know how many options i have?
In other applications like DNN you can define define prefix for each portal's tables.
I looked over web.config file but could not find there either.

Thanks you

7/17/2006 8:09 AM

Geert Veenstra

Joined: 12/24/2002

Posts: 552

It's called objectQualifier and it's set in the dataRe: using prefix in database? Modified By Geert Veenstra on 7/17/2006 8:10:05 AM

It's called objectQualifier and you can set it in the dataprovider section.

Geert Veenstra

7/17/2006 8:18 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: using prefix in database?

please notice, that the aspnet tables of the MS membership provider don't get prefixed and will be shared amongst the istallations.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

7/18/2006 12:09 AM

Tony Valenti

www.PowerDNN.com
Joined: 1/17/2006

Posts: 567

Re: using prefix in database?

Hi Farhad,
Although the object qualifier capability is a great feature in DNN, I would high recommend moving with caution when dealing with it. Once you have the sites fused together, it is virtually impossible to cleanly separate them. Depending on the type of site your building, that may be fine, but if there is ever the possibility that you might want to hand off one of the sites to someone else, I'd say be doubley-doubley sure that you'd be OK with them knowing about everything in all the sites in the DB.

Tony Valenti
Tony.Valenti@PowerDNN.com
+001-402-650-6072

PowerDNN.com - World Leader in DotNetNuke Hosting and DNN Hosting
DNN Hosting Australia - DNN Hosting Europe - DNN Hosting US

7/18/2006 12:22 AM

Geert Veenstra

Joined: 12/24/2002

Posts: 552

Re: using prefix in database?

MobileNow,

I don't get what you are saying. I think the objectQualifier is meant to seperate the tables from each installation.

So installation 1 has objectQualifier inst1 and installation 2 has objectQualifier inst2

Then in the database you will see two Portals tables : inst1_Portals and inst2_Portals

Are you maybe mistaken with running two or more Portals from one database (using a different portalalias) ?

Geert Veenstra

Page 1 of 2

1

using prefix in database?

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)