[GENERAL] DB Design Advice

2009-08-20 Thread stone...@excite.com
Hey all,My company is designing a database in which we intend to store data for several customers.  We are trying to decide if,A:  we want to store all customer data in one set of tables with customer_id fields separating the data or,B:  storing each customers data in a separate schema.I'd like

Re: [GENERAL] DB Design Advice

2009-08-20 Thread stone...@excite.com
>stone...@excite.com wrote: >> Hey all, >> >> My company is designing a database in which we intend to store data >> for several customers. We are trying to decide if, >> >> A: we want to store all customer data in one set of tables with >> customer_id