Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Database diagrams

Database diagrams

Scheduled Pinned Locked Moved The Lounge
databasevisual-studiocomtoolsquestion
35 Posts 28 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C Christian Graus

    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.

    D Offline
    D Offline
    Dave Parker
    wrote on last edited by
    #2

    MS Paint ;P Nah, I usually end up using Visio. There's also things within Access and SQL Enterprise Manager (and I'm guessing management studio but dunno) for it though I've not used them much.

    A 1 Reply Last reply
    0
    • D Dave Parker

      MS Paint ;P Nah, I usually end up using Visio. There's also things within Access and SQL Enterprise Manager (and I'm guessing management studio but dunno) for it though I've not used them much.

      A Offline
      A Offline
      Adam Maras
      wrote on last edited by
      #3

      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

      C M 2 Replies Last reply
      0
      • A Adam Maras

        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

        C Offline
        C Offline
        Christian Graus
        wrote on last edited by
        #4

        OK, I may look at that, it did not even occur to me :~

        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.

        1 Reply Last reply
        0
        • C Christian Graus

          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.

          B Offline
          B Offline
          Brady Kelly
          wrote on last edited by
          #5

          SSMS

          I have been trying for weeks to get this little site indexed. If you wonder what it is, or would like some informal accommodation for the 2010 World Cup, please click on this link for Rhino Cottages.

          1 Reply Last reply
          0
          • A Adam Maras

            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

            M Offline
            M Offline
            Mustafa Ismail Mustafa
            wrote on last edited by
            #6

            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[^]?

            N 1 Reply Last reply
            0
            • C Christian Graus

              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.

              D Offline
              D Offline
              DABBee
              wrote on last edited by
              #7

              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.

              1 Reply Last reply
              0
              • C Christian Graus

                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.

                J Offline
                J Offline
                JimmyRopes
                wrote on last edited by
                #8

                Visio

                Simply Elegant Designs JimmyRopes Designs
                Think inside the box! ProActive Secure Systems
                I'm on-line therefore I am. JimmyRopes

                1 Reply Last reply
                0
                • C Christian Graus

                  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.

                  _ Offline
                  _ Offline
                  _Damian S_
                  wrote on last edited by
                  #9

                  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!!

                  1 Reply Last reply
                  0
                  • C Christian Graus

                    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.

                    R Offline
                    R Offline
                    Rama Krishna Vavilala
                    wrote on last edited by
                    #10

                    What database are you using? SQL Server Management studio or Visual Studio 2008 can easily generate database diagrams. (Only for SQL Server of course).

                    C 1 Reply Last reply
                    0
                    • R Rama Krishna Vavilala

                      What database are you using? SQL Server Management studio or Visual Studio 2008 can easily generate database diagrams. (Only for SQL Server of course).

                      C Offline
                      C Offline
                      Christian Graus
                      wrote on last edited by
                      #11

                      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 D S W 4 Replies Last reply
                      0
                      • C Christian Graus

                        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 Offline
                        A Offline
                        Adam Maras
                        wrote on last edited by
                        #12

                        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

                        1 Reply Last reply
                        0
                        • C Christian Graus

                          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.

                          D Offline
                          D Offline
                          DABBee
                          wrote on last edited by
                          #13

                          Have a look at http://exportsqlce.codeplex.com/ - used with SSMS 2008. Might help.

                          Candy: Don't mess with the prin-cess.

                          C 1 Reply Last reply
                          0
                          • D DABBee

                            Have a look at http://exportsqlce.codeplex.com/ - used with SSMS 2008. Might help.

                            Candy: Don't mess with the prin-cess.

                            C Offline
                            C Offline
                            Christian Graus
                            wrote on last edited by
                            #14

                            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.

                            D 1 Reply Last reply
                            0
                            • C Christian Graus

                              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.

                              P Offline
                              P Offline
                              PIEBALDconsult
                              wrote on last edited by
                              #15

                              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.

                              1 Reply Last reply
                              0
                              • C Christian Graus

                                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.

                                D Offline
                                D Offline
                                DABBee
                                wrote on last edited by
                                #16

                                (Sorry, the linky thingy wasn't working for me- probably need practice)

                                Candy: Don't mess with the prin-cess.

                                C 1 Reply Last reply
                                0
                                • D DABBee

                                  (Sorry, the linky thingy wasn't working for me- probably need practice)

                                  Candy: Don't mess with the prin-cess.

                                  C Offline
                                  C Offline
                                  Christian Graus
                                  wrote on last edited by
                                  #17

                                  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.

                                  D 1 Reply Last reply
                                  0
                                  • C Christian Graus

                                    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.

                                    R Offline
                                    R Offline
                                    r a m e s h
                                    wrote on last edited by
                                    #18

                                    ER/Studio[^]

                                    C 1 Reply Last reply
                                    0
                                    • C Christian Graus

                                      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.

                                      M Offline
                                      M Offline
                                      Mark_Wallace
                                      wrote on last edited by
                                      #19

                                      SELECT, but it's bluddy expensive.

                                      I wanna be a eunuchs developer! Pass me a bread knife!

                                      1 Reply Last reply
                                      0
                                      • C Christian Graus

                                        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.

                                        D Offline
                                        D Offline
                                        DaveAuld
                                        wrote on last edited by
                                        #20

                                        Christian Graus wrote:

                                        Are you on a Mac ? I am and it sometimes doesn't work for me, either.

                                        Did i read correct? something on a Mac that doesn't work........slippery slope approaching! :)

                                        Dave Who am I?: Web|Facebook|Twitter|LinkedIn|Bebo

                                        V 1 Reply Last reply
                                        0
                                        • C Christian Graus

                                          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.

                                          S Offline
                                          S Offline
                                          smcnulty2000
                                          wrote on last edited by
                                          #21

                                          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.

                                          1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups