> -----Original Message----- > From: [email protected] [mailto:[email protected]] > On Behalf Of Jeff Johnson > Sent: Wednesday, February 17, 2010 3:39 PM > To: [email protected] > Subject: Database Design Question > > Looking for opinions here. Most of my customers have several sites. > With VFP I always put different sites in different folders so each site > has identical databases. When considering SQL Server or PostGreSQL > multiple databases seems cumbersome. The other option is to have one > database with one set of tables and have a site field. The problem with > this approach is that there is a chance that a mistake could make one > site's data available to another site. There is a lot of overhead for > printing reports and accessing data to keep thing separate. >
Having one DB does seem like a more sophistimicated approach, and at least you would *know* that your schema matched across all sites.... BUT you're right - one man's 'cumbersome' is another mans 'security'.... Tough call, but if performance is an issue, as you already know the smaller the tables, the better... Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -------------------------------------------------------------------------- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/69f310c05dd83c48a84ba3769ce1ecf802d9d...@tntriexevs02.triadhospitals.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
