How many databases do I need

Below is the work ticket I sent in.


My question: I will be using two different applications, one is a forum and another is an image gallery. Canone database (eg: MS SQL2008) be sufficient to refer both application to when installing? Do I need two?


CJ







-----Original Message-----


From: [email protected] [mailto:[email protected]]


Sent: Sunday, September 28, 2008 6:29 AM


To:


Subject: [TECH-DASP #1224788]: MS SQL 2008





Hello,


You can use one database, although this is beyond our scope of support and we can only provide limited support to programming


related issues. I highly recommend that you post your question on our


community forum at http://community.discountasp.net. We have many


developers who are actively assisting each other within the forum.


Please let us know if you have any further questions.


Thank you,


Joe R.


DiscountASP.NET - Microsoft Gold Certified Partner


- asp.netPRO Magazine 2007 Readers' Choice Award for Best Hosting Service


- Visual Studio Magazine 2007 Readers' Choice Award for Best Hosting Service


On Sat, 27 Sep 2008 17:00:18 -0700, [email protected] wrote:


> This is probably a stupid question, but I'm just an old retired, beaten-up grunt. Please be patient.


> If I have two programs (one a forum and the other a pix gallery), I take it I need to use two different databases? I can't use one database for both applications, can I? </BLOCKQUOTE></BLOCKQUOTE>

 

Hi,
You can indeed use one DB for your site, even the forums.
What you will want to do is make sure you prefix DB objects and tables.

Say for example you are installing the Snitz forums, it will give you a prefix option when you run setup.
Just enter something like SNZ, then your tables will be SNZ_Members, etc.

That will keep one of your apps from interferring with the others.

You will also want to use the Application feature in your Control Panel.
If you install forums with any authentication install them in their own folder.
i.e. \siteroot\forums\

Then with the Applicaiton tool create an application for \forums\

That will help tons in keeping your DB and sessions in order.
Salute,
Mark

 

Thanks! It gets pretty scarey when I start understanding this stuff. I miss the simple life of leading 144 paratroopers, carrying an assault rifle, living off the land with a sole ojective of being a pain-in-the-butt to the enemy. I guess times have changed, and I am just too broken and bent now

Thanks again!

CJ

 

No prob bro...btw, I'm a U.S. Patriot Guard / Honor Guard / Wreaths across America rep.
Salute,
Mark

 

...And I'm C.A.V MU (Canadian Army Veteran Motorcycle Units) www.thecav.ca . Our two orgs have helped each other out on both sides of the border for our repatriated fallen soldiers. I just retired as their National VP after 4 years. Now I'm just a Skirmisher.



CJ (aka Bumpsy)
Major (Retired) CJ Wallace CD, plsc, BA, BAS
Alberta: 403.278.6890
Texas: 903.825.3790
Email

AIRBORNE!
The C.A.V.
VeteranVoice.info (VVi)
HylandMotorshop Inc.

 

Ooh Rah