Avatar of coreybryant
coreybryant
Flag for United States of America asked on

Site With Multiple MSSQL DBs

I have a few sites that use MSSQL db.  Is it better to create a MSSQL DB for each of their programs.

Would it be better to use one MSSQL DB for each script or to have one DB for them all?  Thank you!
Microsoft SQL Server 2008

Avatar of undefined
Last Comment
coreybryant

8/22/2022 - Mon
John Easton

I guess it depends what you are doing.

If the site are totally seperate and have no intergration then I would usually use a seperate database for each.  This potentially has security advantages if one site gets hacked.

Also, if a site is going to have a huge amount of data you may prefer to split this into multiple databases.

However, if the sites do interact however, then one database may be easier.  I.e. one site which is for sales staff and another public site for customers but they share product lists etc.

If you provide more detail of what the site are you may be able to get better advice.
ASKER CERTIFIED SOLUTION
Scott Pletcher

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
coreybryant

ASKER
Thanks all - I would definitely create one MSSQL DB for each site.  I just did not know if having multiple MSSQL DBs would cause the site to load slower.  

I am not worried about having scores of DBs (when it comes to the hosting part).   Basically, some websites have a MSSQL DB for the information that will be displayed and another DB for another script that is being ran on the pages.  Plus some might have an 'ad script' with its own DB.  

So opening one page could possibly need to get access to three databases.  

On one of the scripts, the tables start with an mt_ - so I doubt I would have issues with that.  I have not looked closely at the other names of the tables, but I would think that if the other two scripts have a table named user that might cause some problems.   Of course, I could change one script to begin with ad_ - although that seems like a lot of work.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
coreybryant

ASKER
Thanks - since I was getting ready to move the sites to another server, I wanted to make sure that I started things off right
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck