SQL database Diagrams - Microsoft SQL Server

Pretty new to SQL, but I have had the good luck to be responsible for documenting a very sophisticated program that is a .net application. Anyhow the SQL side of the app is NOT documented with the database diagrams in SQL enterprise manager or with anything else for that matter.

I am not sure how this person setup the relationships/ primary key / foreign keys for these tables , but they appear to have none. How does one untangle the system and use database diagrams (or other tool) to get this system documented?

Any help from the experts is really really appreciated.
Thanks
Curt

Nov 9 '06 #1

Subscribe Post Reply

1830

vssp

268

100+

Visiyo software is helpfull to develop the database diagram

vssp

Nov 10 '06 #2

darkdirk1

visio is nice but the way to go is undoubtedly MicroOlap.
Believe you me - i have designed schemas w/ both and the latter is hugely more intuitive.

Also, though I have never done it, (im pretty sure) if you add your database to Visual Studio 2005 it can spit a diagram out for you - w/out the need to fill in any details.

Nov 10 '06 #3

Similar topics

Database

by: Peter Ellis | last post by:

Hi does anyone know the best way to go about creating a database application? I know quite alot of sql and have access to an oracle server so if...

Java

Need help to understand difference, and contrast between Relational database model and the Object-Oriented model

by: yensao | last post by:

Hi, I have a hard time to understand difference and similarities between Relational database model and the Object-Oriented model. Can somebody...

Oracle Database

Script, Save, Export SQL Database Diagrams

by: Clay Beatty | last post by:

When you create database diagrams in Enterprise Manager, the details for constructing those diagrams is saved into the dtproperties table. This...

Microsoft SQL Server

Script for Transfering Database Diagram

by: Tim Pascoe | last post by:

I've been trying to get the scripts posted earlier to the group by Clay Beatty to work properly. Using the three components he posted, I have...

Microsoft SQL Server

Neat database diagrammatic documentation scheme

by: Steve Jorgensen | last post by:

Recently, I've been working on an Access application that is supposed to be the prototype for a larger system that will be developed by a team using...

Microsoft Access / VBA

Want to be able to create or view database diagrams

by: teedilo | last post by:

Our MS SQL (SQL Server 2000) DBA has database privileges locked down pretty tightly. We end users/developers do not have administrator privileges...

Microsoft SQL Server

Script, Save, Export SQL 2005 Database Diagrams

by: craig dunn | last post by:

I've used the code from the post for a while now... but recently upgraded to SQL Server 2005. I've written a new script for SQL Server 2005,...

Microsoft SQL Server

Knowledgeable yet simple book for database modelling or database design

by: vicky | last post by:

Hi All, Can u please suggest me some books for relational database design or database modelling(Knowledgeable yet simple) i.e. from which we could...

Microsoft SQL Server

Database diagrams disappeared after attaching the database on different machine

by: mca47378 | last post by:

Hi, I attached my database on different machine. Everything seems to be okay as of now, but I dont see my database diagrams here, which I had...

Microsoft SQL Server

Tips for Saving Money on Buying a Gaming Laptop

by: tammygombez | last post by:

Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...

Computer Hardware

The Top 5 Skills You Need in a PowerApps Developer

by: concettolabs | last post by:

In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...

.NET Framework

Discuss your understanding of the Java platform.

by: better678 | last post by:

Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...

General

List of Topmost 8 Electronics Engineering Forum Websites

by: teenabhardwaj | last post by:

How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...

General

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...

General

how to collapse a custom toolbar in VBA

by: CD Tom | last post by:

This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...

General

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...

Oracle Database

https redirect with reverse proxy

by: jalbright99669 | last post by:

Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...

IIS / Internet Information Server

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

General