Database diagrams
-
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/[^]
-
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.
For new database SQL Server Management Studio. For reverse eng of existing db Visio 2007. Works like a charm (if you don't mind occasionaly updateing database model in Visio...
-
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 too use Visio. Visio can be used to create just about every aspect for your database including the different type of relationships, indexes, and constraints. However, where Visio can be used to automically create a database diagram from an existing database, it cannot be used to create your database directly from the Visio diagram (at least the version of Visio I have can't do it - MS Office Visio 2007). Luckily there are free add-ons out there that can do it for you. I downloaded one called OrthogonalToolbox (http://www.orthogonalsoftware.com/products.html[^]) that seems to work OK with Visio 2007 even though I think it was made for Visio 2002. I'm sure there are others out there that may even work better. Anyway, I think it's important to know that because my original assumption with Visio was that it would create my database for me when I was done designing it. Little did I know...
-NP Never underestimate the creativity of the end-user.
-
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.
Since you have MSDN, why not install the SQL Server Developer's Edition? I (at least yesterday) used the Enterprise Manager to design the database to the field/PK level - then use the create diagram feature. It was simple, from there, to create the FK dependencies (click and drag cursor from one to the other). You can also add rows should you have forgotten any. Designer can then be instructed to rearrange the tables, connecting the dependencies that you just created with minimal overlap. Sure - Visio has more bells and whistles - but this is clean & simple.
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"As far as we know, our computer has never had an undetected error." - Weisert"It's a sad state of affairs, indeed, when you start reading my tag lines for some sort of enlightenment. Sadder still, if that's where you need to find it." - Balboos HaGadol
-
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.
The great tool I'm using in everyday work, with great support for diagrams (SQL Server, Oracle, MySQL) is DatabaseSpy from Altova. Take a look at http://www.altova.com/databasespy.html
-
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 Enterprise Architect, from Sparx Systems. It is pretty good: http://www.sparxsystems.com/products/ea/index.html[^] It is useful not only for database diagrams but also for UML. Walter
-
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[^]?
I also do it always from the designer since SQL Server 2000
NoelPV2