Database diagrams
-
Dave Parker wrote:
(and I'm guessing management studio but dunno)
SSMS indeed has a great database diagram tool; the only downside is that it only works against a live database. When you create and modify tables, they're committed to the database upon saving the diagram. In my case, this works great, because I just start out with a blank database and build the entire structure with the designer.
Adam Maras | Software Developer Microsoft Certified Professional Developer
I thought everyone does it that way! I've been doing it (mostly) from the designer since 2000! :~
If the post was helpful, please vote, eh! Current activities: Book: Devils by Fyodor Dostoyevsky Project: Hospital Automation, final stage Learning: Image analysis, LINQ Now and forever, defiant to the end. What is Multiple Sclerosis[^]?
-
What software do people use to create database diagrams ? My VS doesn't seem to offer anything ( I thought it did ), and I wanted to double check before I install Visio ( which is what I'd assume my next step is ). I have an MSDN sub, so whatever tends to be used, I probably have it.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
For VS 2008 search help for Adding and Changing a Database Diagram. (Diagram is based in Server Explorer) Have only used it for SQL Server tho. Used Visio reverse engineer for both SQL Server and Oracle but there has to be a better tool. Cheers. (Oh and yeah the same thing is in SSMS)
Candy: Don't mess with the prin-cess.
-
What software do people use to create database diagrams ? My VS doesn't seem to offer anything ( I thought it did ), and I wanted to double check before I install Visio ( which is what I'd assume my next step is ). I have an MSDN sub, so whatever tends to be used, I probably have it.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
Visio
Simply Elegant Designs JimmyRopes Designs
Think inside the box! ProActive Secure Systems
I'm on-line therefore I am. JimmyRopes -
What software do people use to create database diagrams ? My VS doesn't seem to offer anything ( I thought it did ), and I wanted to double check before I install Visio ( which is what I'd assume my next step is ). I have an MSDN sub, so whatever tends to be used, I probably have it.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
What database are you using? SQL Server Management studio or Visual Studio 2008 can easily generate database diagrams. (Only for SQL Server of course).
-
What software do people use to create database diagrams ? My VS doesn't seem to offer anything ( I thought it did ), and I wanted to double check before I install Visio ( which is what I'd assume my next step is ). I have an MSDN sub, so whatever tends to be used, I probably have it.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
Visio is particularly good if you have an existing DB you want to reverse-engineer the design from... Of course, it's also good to go the other way, although I still prefer to just use it to document and create the db by hand, but that's just me...
I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!
-
What database are you using? SQL Server Management studio or Visual Studio 2008 can easily generate database diagrams. (Only for SQL Server of course).
SQL Server Compact, that appears to be why I am limited in my options. I may create a SQL Server Database in the management console, then generate SQL to create my end DB.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
SQL Server Compact, that appears to be why I am limited in my options. I may create a SQL Server Database in the management console, then generate SQL to create my end DB.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
A wise course of action; I did the same thing with a SQL Server Compact project some months ago, never ran into a single problem. In fact, I may do the same with the project I'm working on :laugh:
Adam Maras | Software Developer Microsoft Certified Professional Developer
-
SQL Server Compact, that appears to be why I am limited in my options. I may create a SQL Server Database in the management console, then generate SQL to create my end DB.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
Have a look at http://exportsqlce.codeplex.com/ - used with SSMS 2008. Might help.
Candy: Don't mess with the prin-cess.
-
Have a look at http://exportsqlce.codeplex.com/ - used with SSMS 2008. Might help.
Candy: Don't mess with the prin-cess.
Thanks, I will. http://exportsqlce.codeplex.com[^]
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
What software do people use to create database diagrams ? My VS doesn't seem to offer anything ( I thought it did ), and I wanted to double check before I install Visio ( which is what I'd assume my next step is ). I have an MSDN sub, so whatever tends to be used, I probably have it.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
The hard way... SSMS | Views | Create view | Add the tables I want I generally don't keep database diagrams; I tend to use them only to check whether or not I created the relations properly.
-
Thanks, I will. http://exportsqlce.codeplex.com[^]
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
(Sorry, the linky thingy wasn't working for me- probably need practice)
Candy: Don't mess with the prin-cess.
That's cool, i pasted it out of laziness. Are you on a Mac ? I am and it sometimes doesn't work for me, either.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
What software do people use to create database diagrams ? My VS doesn't seem to offer anything ( I thought it did ), and I wanted to double check before I install Visio ( which is what I'd assume my next step is ). I have an MSDN sub, so whatever tends to be used, I probably have it.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
What software do people use to create database diagrams ? My VS doesn't seem to offer anything ( I thought it did ), and I wanted to double check before I install Visio ( which is what I'd assume my next step is ). I have an MSDN sub, so whatever tends to be used, I probably have it.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
SELECT, but it's bluddy expensive.
I wanna be a eunuchs developer! Pass me a bread knife!
-
That's cool, i pasted it out of laziness. Are you on a Mac ? I am and it sometimes doesn't work for me, either.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
What software do people use to create database diagrams ? My VS doesn't seem to offer anything ( I thought it did ), and I wanted to double check before I install Visio ( which is what I'd assume my next step is ). I have an MSDN sub, so whatever tends to be used, I probably have it.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
Depends on why I'm making them. for documentation I use Visio or PowerPoint when I don't have access to Visio. Admittedly I'm usually on a client's machine. Anything else... Pen and paper if I'm thinking through something. x
_____________________________ There is no I in team. But there is meat in there.
-
What software do people use to create database diagrams ? My VS doesn't seem to offer anything ( I thought it did ), and I wanted to double check before I install Visio ( which is what I'd assume my next step is ). I have an MSDN sub, so whatever tends to be used, I probably have it.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
REAL sql developers do EVERYTHING with scripts :-D
____________________________________________________________ Be brave little warrior, be VERY brave
-
What software do people use to create database diagrams ? My VS doesn't seem to offer anything ( I thought it did ), and I wanted to double check before I install Visio ( which is what I'd assume my next step is ). I have an MSDN sub, so whatever tends to be used, I probably have it.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
Noooo!!!! You've got that all wrong! It's not the Mac that's not working, it's the browser/web site/something else ;P
Vincent www.pub-olympics.com
-
What software do people use to create database diagrams ? My VS doesn't seem to offer anything ( I thought it did ), and I wanted to double check before I install Visio ( which is what I'd assume my next step is ). I have an MSDN sub, so whatever tends to be used, I probably have it.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
I use http://www.evolus.vn/Pencil/[^]