Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Split large database model into smaller parts

Pergunta Split large database model into smaller parts

  • Monday, October 10, 2011 1:36 PM
     
     
    Sign In to Vote
    0

    Hi everybody.

    I got a large database with a lot of tables, and want to get a grip on the structure by creating a solution in VS 2010, and make a databaseModel. I've done that, but it's impossible to get something out of it, only small tiny boxes with lines between. I want to split it into logical parts, like have a Main-view, or something, and a bunch of nodes/models attached to it, which everyone of those contains a smaller logical grop of tables. Is it possible in VS2010 Ultimate? I do not want to create several projects, like 1 project/group if I can avoid it. Just some grouping in the same project.

    Thanks in advance,

    /Erik

    Erik
     

All Replies

  • Tuesday, October 11, 2011 3:34 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Erik,

    Do you mean that break up a large entity model into smaller ones using entity framework? If that is the case, please have a look the following blogs on this topic:

    Working With Large Models In Entity Framework – Part 1
    Working With Large Models In Entity Framework – Part 2

    Best Regards,
    Stephanie Lv

    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
     
  • Thursday, October 13, 2011 7:59 AM
     
     
    Sign In to Vote
    0

    Hi, thanks for your reply, but it was not exactly what I ment. I just want a way to make a database project, and divide the tables into logical parts, just to get a nice view of it (and update tables when needed). I have discovered, if I create a such project in VS2010, I can see it in Sql server management stuio, but still... cannot divide it.

    I got another tool to test right now, but thx for your suggestion.

     

    Erik