locked
How to create a database diagram in Visual Studio 2015? RRS feed

  • Question

  • Hi all,

    I am sorry, but I was not sure if this question does belong here.

    So, ... how to create a database diagram in Visual Studio 2015?

    Thank you.

    Friday, March 13, 2020 12:30 PM

Answers

  • [..] which is included in Visual Studio, so I dont need another program. [..]

    Well, that's the problem, SSDT does not include such a tool as far as I know. Thus you need a separate program.

    ... I just want to see that tables connected ... like image ... i hope u understand me

    Understood.

    Either you use some MS tools like SSMS, which is free, or Visio, which is not. Or you look into third party tools like DB Designer Fork

    • Marked as answer by TakeshiKitano Friday, March 20, 2020 11:03 AM
    Monday, March 16, 2020 10:07 AM

All replies

  • hmm, I'm not aware of database diagrams in VS, only in SSMS.

    The question is: What do you like to do with them?

    I found external tools like Visio or Redgate Dependency Tracker more useful.

    • Marked as answer by TakeshiKitano Friday, March 13, 2020 12:42 PM
    • Unmarked as answer by TakeshiKitano Friday, March 13, 2020 12:42 PM
    Friday, March 13, 2020 12:39 PM
  • I have som tables connected with foreign keys. I use mdf database which is included in Visual Studio, so I dont need another program. I am not if it is good database ... before I user SQLite ...

    ... I just want to see that tables connected ... like image ... i hope u understand me

    Friday, March 13, 2020 12:44 PM
  • I have som tables connected with foreign keys. I use mdf database which is included in Visual Studio, so I dont need another program. I am not if it is good database ... before I user SQLite ...

    ... I just want to see that tables connected ... like image ... i hope u understand me

    The MS SQL Express  MDF standalone file is created by Visual  Studio's Service Based Database feature, which is a Localdb file. 

    You should understand what you are using when you make a MDF file using VS's Service Based Database.

    https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-ver15

    https://dotnetthoughts.net/connecting-localdb-using-sqlserver-management-studio/

    About the database diagram, then let the DBA(s) help you. They can help you with all of what you are needing.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-us/home?forum=sqlexpress

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

    Saturday, March 14, 2020 7:54 AM
  • [..] which is included in Visual Studio, so I dont need another program. [..]

    Well, that's the problem, SSDT does not include such a tool as far as I know. Thus you need a separate program.

    ... I just want to see that tables connected ... like image ... i hope u understand me

    Understood.

    Either you use some MS tools like SSMS, which is free, or Visio, which is not. Or you look into third party tools like DB Designer Fork

    • Marked as answer by TakeshiKitano Friday, March 20, 2020 11:03 AM
    Monday, March 16, 2020 10:07 AM