locked
Multiple Database Design in ASP RRS feed

  • Question

  • what is your opinion about this design for a web2 that stores huge size of independence datas.

    have an master database for user acounts and create small slave database per each user to store and posts and comments and ... from slave database.

    [multiple database]

    is it good idea for sql server and asp.net

    // i done this plan and it works fine but not still publish it to web.


    Friday, May 20, 2011 7:02 PM

Answers

  • You can create one database with different table having foreign key reference. if you create different databases maintain referential integrity is difficult which allow application insert bad data. 
    http://uk.linkedin.com/in/ramjaddu
    Friday, May 20, 2011 7:40 PM
  • Hi,
    Could you please provide more specific example or database schema? If you want to create a user account table in main database and store the related information of each user in particular slave database, the data integrity is a concern. Or you just want to use slave database for data synchronization purpose. For example, you have all users’ information in five tables of main database and the slave database only store the separate user’s information in five tables itself . In this case, using SSIS could be one of the options.
    Hope this helps.

    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Tuesday, May 24, 2011 2:17 AM
    Answerer

All replies

  • You can create one database with different table having foreign key reference. if you create different databases maintain referential integrity is difficult which allow application insert bad data. 
    http://uk.linkedin.com/in/ramjaddu
    Friday, May 20, 2011 7:40 PM
  • Hi,
    Could you please provide more specific example or database schema? If you want to create a user account table in main database and store the related information of each user in particular slave database, the data integrity is a concern. Or you just want to use slave database for data synchronization purpose. For example, you have all users’ information in five tables of main database and the slave database only store the separate user’s information in five tables itself . In this case, using SSIS could be one of the options.
    Hope this helps.

    Best Regards,
    Peja

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Tuesday, May 24, 2011 2:17 AM
    Answerer
  • Do you have a dilemma having one database per user or storing all info in one database?  
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Tuesday, May 24, 2011 5:41 AM
  • what is your opinion about this design for a web2 that stores huge size of independence datas.

    have an master database for user acounts and create small slave database per each user to store and posts and comments and ... from slave database.

    [multiple database]

    is it good idea for sql server and asp.net

    // i done this plan and it works fine but not still publish it to web.



    Are you trying to implement some sort of security for each user so that they can't see/alter other user data?  if so, this can be done with one database and 1 post table.  All you need to do is add a column to store the users unique ID.
    Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA Blog: MrWharty.wordpress.com
    Wednesday, May 25, 2011 5:33 AM