Creating SQL databases for customer data

Tags:
SQL Database
I am creating an application that potentially has quite a lot of rows of data for hundreds of customers. Each set of customer data is only for that customer. There may be some future requirement to summarize the data for all customers, but that is not currently needed. Would it be better to place all the transactional data within one SQL database and one table or separate the customers' data into different SQL databases?

Answer Wiki

Thanks. We'll let you know when a new response is added.

I would recommend placing the data all within a single database, using the CustomerId to separate the data from Customer to Customer. This way you can report at the single customer level which your current requirements state, as well as leave yourself open to potential future requirements of reporting against all customers.

Also by having all data within a single database database maintenance is simple. With each customers data on its own database your maintenance and connection string become difficult.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,125 pointsBadges:
    report
  • SQL Server Ask the Experts
    [...] IP Democracy wrote an interesting post today onHere’s a quick excerpt New Discussion Post by Mrdenny [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following