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. VS Server Explorer or SQL Management Studio

VS Server Explorer or SQL Management Studio

Scheduled Pinned Locked Moved The Lounge
wpfcsharpdatabasevisual-studiocom
13 Posts 9 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.
  • L Lost User

    I always have used Management Studio and don't want to waste any time getting to know sever explorer in VS if it's not up to the job - so have you experience of both? which do you use, and why? Ta

    MVVM# - See how I did MVVM my way ___________________________________________ Man, you're a god. - walterhevedeich 26/05/2011 .\\axxx (That's an 'M')

    M Offline
    M Offline
    Mycroft Holmes
    wrote on last edited by
    #4

    I tried, I really did try and use the VS data projects and server explorer. Originally I wanted to take advantage of source control and have 1 integrated platform. Then I chucked it for SSMS, just like I don't think the clr belongs in the database I don't think the database belongs in VS.

    Never underestimate the power of human stupidity RAH

    1 Reply Last reply
    0
    • L Lost User

      I always have used Management Studio and don't want to waste any time getting to know sever explorer in VS if it's not up to the job - so have you experience of both? which do you use, and why? Ta

      MVVM# - See how I did MVVM my way ___________________________________________ Man, you're a god. - walterhevedeich 26/05/2011 .\\axxx (That's an 'M')

      R Offline
      R Offline
      Ravi Bhavnani
      wrote on last edited by
      #5

      I use SMS for 90% of my database needs.  I use Server Explorer only when I need to drag tables into a .dbml file. /ravi

      My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

      1 Reply Last reply
      0
      • L Lost User

        I always have used Management Studio and don't want to waste any time getting to know sever explorer in VS if it's not up to the job - so have you experience of both? which do you use, and why? Ta

        MVVM# - See how I did MVVM my way ___________________________________________ Man, you're a god. - walterhevedeich 26/05/2011 .\\axxx (That's an 'M')

        J Offline
        J Offline
        JustWorking
        wrote on last edited by
        #6

        I only use server explorer to view table names and field names :rolleyes:

        P 1 Reply Last reply
        0
        • L Lost User

          I must admit the main reason i was contemplating it was that I now have a VS config over two monitors - and the 2nd monitor hides the SSMS window unless they are carefully positioned - and the Wibn7 docking doesn't work on the VS child windows - so I figured if only I could dock SSMS into the VS docking system , I would have the best of both worlds...

          MVVM# - See how I did MVVM my way ___________________________________________ Man, you're a god. - walterhevedeich 26/05/2011 .\\axxx (That's an 'M')

          A Offline
          A Offline
          Andy_L_J
          wrote on last edited by
          #7

          VS Server Manager Sux - There's a whole new thread right there. SSMS it is.

          I don't speak Idiot - please talk slowly and clearly 'This space for rent' Driven to the arms of Heineken by the wife

          1 Reply Last reply
          0
          • L Lost User

            I always have used Management Studio and don't want to waste any time getting to know sever explorer in VS if it's not up to the job - so have you experience of both? which do you use, and why? Ta

            MVVM# - See how I did MVVM my way ___________________________________________ Man, you're a god. - walterhevedeich 26/05/2011 .\\axxx (That's an 'M')

            C Offline
            C Offline
            costavo
            wrote on last edited by
            #8

            stay a Pro. and keep using the SQL Server Management Studio. VS explorer is for beginners...

            H 1 Reply Last reply
            0
            • L Lost User

              I always have used Management Studio and don't want to waste any time getting to know sever explorer in VS if it's not up to the job - so have you experience of both? which do you use, and why? Ta

              MVVM# - See how I did MVVM my way ___________________________________________ Man, you're a god. - walterhevedeich 26/05/2011 .\\axxx (That's an 'M')

              R Offline
              R Offline
              R Giskard Reventlov
              wrote on last edited by
              #9

              SSMS for the database, VS2010 for asp.net/c#. Why would you do it any other way? :)

              "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me

              L 1 Reply Last reply
              0
              • C costavo

                stay a Pro. and keep using the SQL Server Management Studio. VS explorer is for beginners...

                H Offline
                H Offline
                Henry Minute
                wrote on last edited by
                #10

                costavo wrote:

                VS explorer is for beginners

                Sorry, but that's nonsense. Both have their uses. Obviously DBAs and the like would use SSMS but there are many times when VS Server Explorer can do things that SSMS simply cannot do. The example already given of populating a LINQ to SQL class being just one.

                Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

                P 1 Reply Last reply
                0
                • R R Giskard Reventlov

                  SSMS for the database, VS2010 for asp.net/c#. Why would you do it any other way? :)

                  "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me

                  L Offline
                  L Offline
                  Lost User
                  wrote on last edited by
                  #11

                  digital man wrote:

                  Why would you do it any other way?

                  I dunno -that's why I was askin' ;)

                  MVVM# - See how I did MVVM my way ___________________________________________ Man, you're a god. - walterhevedeich 26/05/2011 .\\axxx (That's an 'M')

                  1 Reply Last reply
                  0
                  • J JustWorking

                    I only use server explorer to view table names and field names :rolleyes:

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

                    I use my database-agnostic command-line tool or that.

                    1 Reply Last reply
                    0
                    • H Henry Minute

                      costavo wrote:

                      VS explorer is for beginners

                      Sorry, but that's nonsense. Both have their uses. Obviously DBAs and the like would use SSMS but there are many times when VS Server Explorer can do things that SSMS simply cannot do. The example already given of populating a LINQ to SQL class being just one.

                      Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” I wouldn't let CG touch my Abacus! When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.

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

                      Henry Minute wrote:

                      LINQ to SQL

                      Which is for beginners. :-D

                      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