Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
HOVE
Starting Member
2 Posts |
 Posted - 2009-10-12 : 17:26:27
|
| I need a opinion about a design of a financial database. It would be a web WPF application. For our every client there would be separate database, these databases would be of same design. Every our client would have their own clients. There is three possibilities how we could incorporate data for clients of our clients: 1. make a separate database for every client, so there would be a database for every our client and their clients2. have a database for every our client and group their clients by schemes, for an example: Client1Sales3. have a database for every our client and their is only one instance of their clients tables where all clients data residesWhat is the best approach? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-10-12 : 19:09:16
|
| I would use one database with many clients as you don't want to be in a position to have thousands of databases to support. I would only use one schema too.The systems that I support have hundreds or thousands of customers all in one database and all using one schema. You just need to properly design your database and indexes in order to support it efficiently.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
 |
|
|
HOVE
Starting Member
2 Posts |
Posted - 2009-10-13 : 02:44:35
|
| But is there not a law saying that financial data shouldn't be physically in one place, that even in OLTP environments it should be separated? |
|
|
|
Liz Lyons
Starting Member
22 Posts |
Posted - 2009-10-13 : 08:52:14
|
| I dunno, but might be worth also asking Robin Dewson at http://www.fat-belly.com. I'm learning from a book of his and it seems he knows about financial systems and is strong on SQL Server databases and might reply to an e-mail. Might be a wasted e-mail, but might help. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Design of a financial database