This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » SQL and Databases » Database to run multiple websites

Database to run multiple websites
Andy None Member Since: 30 Apr 2009 Posts: 17	Posted 26 Oct 2009 13:00:05 I'd like some advise or case studdies on running multiple websites from one database. I'm looking to use either MySQL or MS SQL. At the moment i'm using individual Access Databse's for each of our sites, but now the sites are growing, i would like to centralise the data. The sites are e-commerce, but i will also be creating microsites which are fed from the one database. Another requirement is to pull data from our local Sage MS SQL database to feed live stock control of the e-commerce sites. How feasible is this? and what security issues should i be thinking about? In short, i want to use a robust DB to serve our websites (we rent virtual hosting from a local company)but also pull data from our Sage databse which we host internally). A bit of a tough one i reckon, but hope to get some helpful replies. Thanks in advance Andy I'd like some advise or case studdies on running multiple websites from one database. I'm looking to use either MySQL or MS SQL. At the moment i'm using individual Access Databse's for each of our sites, but now the sites are growing, i would like to centralise the data. The sites are e-commerce, but i will also be creating microsites which are fed from the one database. Another requirement is to pull data from our local Sage MS SQL database to feed live stock control of the e-commerce sites. How feasible is this? and what security issues should i be thinking about? In short, i want to use a robust DB to serve our websites (we rent virtual hosting from a local company)but also pull data from our Sage databse which we host internally). A bit of a tough one i reckon, but hope to get some helpful replies. Thanks in advance Andy

Database to run multiple websites

Andy None
Member

Since: 30 Apr 2009
Posts: 17

Posted 26 Oct 2009 13:00:05

I'd like some advise or case studdies on running multiple websites from one database.
I'm looking to use either MySQL or MS SQL.
At the moment i'm using individual Access Databse's for each of our sites, but now the sites are growing, i would like to centralise the data. The sites are e-commerce, but i will also be creating microsites which are fed from the one database.
Another requirement is to pull data from our local Sage MS SQL database to feed live stock control of the e-commerce sites.
How feasible is this? and what security issues should i be thinking about?
In short, i want to use a robust DB to serve our websites (we rent virtual hosting from a local company)but also pull data from our Sage databse which we host internally).
A bit of a tough one i reckon, but hope to get some helpful replies.

Thanks in advance
Andy

I'd like some advise or case studdies on running multiple websites from one database.
I'm looking to use either MySQL or MS SQL.
At the moment i'm using individual Access Databse's for each of our sites, but now the sites are growing, i would like to centralise the data. The sites are e-commerce, but i will also be creating microsites which are fed from the one database.
Another requirement is to pull data from our local Sage MS SQL database to feed live stock control of the e-commerce sites.
How feasible is this? and what security issues should i be thinking about?
In short, i want to use a robust DB to serve our websites (we rent virtual hosting from a local company)but also pull data from our Sage databse which we host internally).
A bit of a tough one i reckon, but hope to get some helpful replies.

Thanks in advance
Andy

Mark Kujoy Member Since: 22 May 2001 Posts: 12	Replied 25 Mar 2010 23:32:40 Using a single database for multiple websites is very easy, and there are quite a few ways it can be done. You can also manage all the sites from a single CMS system. If you are using PHP and dreamweaver, you can really only use MySQL, MSSQL is gonna cause you probems, theres no real off the shelf way to link PHP and MSSQL anymore. ASP then you can use MSSQL and I think MySQL (its been a while) Most hosts allow remote connections to the database, so you can connect to the database from a website your designng on your desktop. You can also use the same connection string on more than one site and if your careful with your table naming you can use the database for as many sites as you want. You might want name your tables: tbl_website_name_product_details or something similar. Or if you have more than one site using the same information you can vary what you pull out of the database using a recordset and sorting the information using an entered value that pulls the records you want without needing a querystring cookie or session value. I build these kind of sites everyday so if you want a hand email me at Edited by - Mark Kujoy on 25 Mar 2010 23:34:24 Edited by - Mark Kujoy on 25 Mar 2010 23:35:36 Edited by - Mark Kujoy on 25 Mar 2010 23:36:24

Kitty Crichtonp Member Since: 21 Jan 2012 Posts: 1	Replied 21 Jan 2012 10:40:02 Paypal is makeing her have a seperate paypal pro account for each website, and a seperate buiseness bank account for each. Relift Xs