CODEWITHSUNDEEP
sql-servervisual-studio-2012
Coop
Coop

Reputation: 55

Can Visual Studio replace MS Sql Server Manager?

I've been using Dreamweaver and MS SQL Server Management tool. I've recently got Visual Studio 12. I would like to only use Visual Studio.

When I right click on a table in the db I don't get the Script Table As options.

Upvotes: 0

Views: 388

Answers (2)

Orlando Herrera
Orlando Herrera

Reputation: 3531

If you want to have a complete administration of your database I would recommend you to use MS SQL Server Management tool, because you can to do tasks like:

  • Administrator privileges
  • Security
  • Maintenance plans

(Only mentioning a couple of tasks. There are more.)

If you want to create a fast DB with the basic tasks with VStudio will be enough.

I will write a couple of links that you can visit, I hope this can help you more:

Upvotes: 1

alroc
alroc

Reputation: 28144

No, and it's not intended to. SSMS has a lot of functionality which Visual Studio's Server Explorer doesn't, and shouldn't, attempt to reproduce.

For certain use cases, you may only need the functionality exposed within Visual Studio. But I wouldn't want to be without SSMS and all of the tools it includes. Trying to limit your usage to only VS sounds like cutting off your nose to spite your face.

Upvotes: 3

Related Questions