-5

I created a window application in which I used SQL Server as backend database. But I want to know that is there a way through which we do not need SQL Server Management Studio to be installed on system?

I used Entity Framework with a code-first approach which creates database automatically but needs connection string for that. I need a way through which I can provide connection string of SQL Server Express without installing Management Studio.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Manprit Singh
  • 825
  • 2
  • 8
  • 18
  • 3
    SSMS is just an IDE for developers / admins to interface with SQL Server. Applications don't need SSMS _at all_ to function - they just need a proper connection string and use database-related objects to connect. – xxbbcc Dec 10 '15 at 20:30
  • 4
    Downvoting per clear lack of research. – Camilo Terevinto Dec 10 '15 at 20:31
  • Try [using the Data Link Properties wizard](http://stackoverflow.com/a/10480011/205233) – Filburt Dec 10 '15 at 20:34

2 Answers2

1

You only need to install SQL Server, Management Studio is just for an easier database and server management, but it's not required to make SQL Server services work.

Camilo Terevinto
  • 31,141
  • 6
  • 88
  • 120
rhernandez
  • 304
  • 2
  • 11
1

Try using SQL Server Data Tools (SSDT). You can create, manage and deploy SQL Server code right from Visual Studio.

It's built into VS 2013 and up and can be downloaded as an addin all the way down to VS 2010.

https://msdn.microsoft.com/en-us/library/mt204009.aspx

Randy
  • 2,270
  • 1
  • 15
  • 24