The Voice of the DBA - WMV A Private Database

MEVIOtoday

Jun 08, 2008 A Private Database

One of the things I've dealt with, and seen lots of questions about in our forums, is the best way to deal with multiple clients using the same schema and lookup data for an application. I've seen two basic ways that this is handled in SQL Server: some people put everything in one database and use some type of ID to filter results. Others use separate databases for each client and either keep lookup data in a central database, so each client has two databases they access, or use some copy method, such as replication, to ensure the lookup data is in every client's database. Both of these have pros and cons and each company needs to examine their situation to determine which method makes sense.

Read the rest of A Private Database at SQLServerCentral.com