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 Offline
    L Offline
    Lost User
    wrote on last edited by
    #1

    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')

    P M R J C 6 Replies 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')

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

      I only use SSMS. Integration into VS is just wrong.

      L 1 Reply Last reply
      0
      • P PIEBALDconsult

        I only use SSMS. Integration into VS is just wrong.

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

        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 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')

          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