Stack Overflow
Stack Overflow

Questions tagged [database-diagram]

62 questions
3
votes
2 answers

How to successfully migrate/copy a database diagram from different servers

Background: Our database was originally being hosted by a third party hosting company on a shared server. We did not have the permissions to create database diagrams, so the quick solution was to create a diagram on .\sqlexpress just for ease. Now…
WhatsThePoint
  • 3,395
  • 8
  • 31
  • 53
3
votes
1 answer

SQL Server: create database diagram by query

I've been wondering if it's possible to create a database diagram by query instead of going through adding it manually in Management Studio. Has anyone of you done this before?
Xaphas
  • 501
  • 4
  • 20
3
votes
3 answers

How to set-up a database diagram from existing tables?

I have a database which has almost 300 tables, I've just come across with a problem that I've added almost 60 tables into my diagram. I can only view the entire page if I set the page zoom to %10 and it's not really useful. Anyone has any…
Fırat Tuncer
  • 85
  • 2
  • 6
3
votes
1 answer

How to create a database diagram with Enterprise Architect and an Oracle database?

I need to create a database diagram in Enterprise Architect. I understand how I can create each table and add the columns by hand. But that will take me a really long time. The database is Oracle 11g and I use Oracle SQL Developer. Is there any way…
jeph perro
  • 6,242
  • 26
  • 90
  • 124
3
votes
1 answer

How to make SchemaCrawler work in Windows?

How to make SchemaCrawler to work in Windows? GraphViz is installed. Now I'm trying to make a diagram of a whole PostgreSQL database using the command line: sc.cmd -command graph -outputformat png \ -outputfile=graph.png -database=my_database \ …
Paul
  • 25,812
  • 38
  • 124
  • 247
2
votes
0 answers

SQL Server 2017 Developer : database diagram folder missing

I have a problem with database diagram folder.. I cannot find it anywhere. I've looked everywhere. I've downloaded sample database and used it as db owner but it didn't work.
user9753084
  • 31
  • 5
2
votes
1 answer

Importance / use / advantages of creating database diagram in sql server

I am relatively new to sql server and we are using sql server 2014 version in my workplace. Why do we actually need this database diagram in sql server(using SSMS)?
Arockia Nirmal
  • 737
  • 1
  • 6
  • 20
2
votes
2 answers

Database symbol meaning?

I was going through some tutorials and came across the below database diagram: I didn't understand this database diagram. Can anyone help me in understanding these notations? Are they made using UML or Visio or what?
CuriousMind
  • 8,301
  • 22
  • 65
  • 134
2
votes
1 answer

SQL Server Database Diagram Show relationships

There is a database online that I was able to download. It came in Access, I exported it to SQL Server. It works beautifully. However when I create a diagram, it doesn't show the relationships. By that I mean I would like to see a line connecting…
dwarf
  • 445
  • 2
  • 9
  • 23
1
vote
0 answers

How to resize attribute boxes in Visio attributes

This is a very simply request, but I cannot locate the solution. I have Visio 2016 and the layout within Visio is using the Crows foot database notation, with Entities and Attributes within. However, it appears I cannot change the thickness of a…
Sauron
  • 6,399
  • 14
  • 71
  • 136
1
vote
1 answer

Should we break One to Many Relation which is unidirectional into a JoinTable

I am currently working on an application where I have 2 Tables. User and Team. User has UserId as PK and UserPassword. Team table has TeamId as PK and TeamName. Originally I had one single table where I had UserId, UserPassword and TeamId but it…
Kshitiz Bathwal
  • 87
  • 1
  • 10
1
vote
2 answers

Out of bound of array error while creating Database Diagram SQL Server 2017

I am using SSMS 2017 and my database is SQL Server 2016 Enterprise. An error is being shown while creating a database diagram: The index is out of bound of array How to resolve it? Thank you in advance
Abubakar Riaz
  • 320
  • 8
  • 26
1
vote
0 answers

After installing latest SSMS, error only when creating database diagram

Perhaps it's coincidental, since I very rarely do DBA, but after installing the latest SSMS yesterday I tried to create a database diagram for a database and received the following error: Could not obtain information about Windows NT group/user…
jlear
  • 160
  • 1
  • 3
  • 14
1
vote
1 answer

EER Diagram - Mixing Specialization and Disjointness Constraints Among Subtypes

I'm trying to design an EER diagram that has the supertype Student with the following subtypes: Undergraduate, Graduate, and Research Assistant. A Student must be either an Undergraduate or a Graduate, and a Student may or may not be a Research…
Demagogue
  • 13
  • 4
1
vote
0 answers

Adding additional display data to Sql Server Database Diagrams

I could not find on the internet resources that show how can I make a Sql Server Database Diagram show each table's unique indexes. I know I can: Add relationship labels - not what I want. Play with the options in right-clicking a table in the…
Veverke
  • 9,208
  • 4
  • 51
  • 95
1
2
3 4 5