Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to create a database in MS Visual Studio 2013?

I have tried and searched a lot on internet but found no way of creating a database in Ms Visual Studio 2013.

I am learning basics in c#. I have SQL Server 2008 at bakend.

like image 522
Umair Ayub Avatar asked Dec 02 '13 16:12

Umair Ayub


People also ask

How do I create a new database in Visual Studio?

In the Data Sources window, select Add New Data Source. The Data Source Configuration Wizard opens. On the Choose a Data Source Type page, choose Database and then choose Next.


1 Answers

If you not only want to create a database, but plan longer development using Visual Studio, then create new project of database type (File -> New Project, then select Templates, Other Languages, SQL Server, SQL Server Database Project). You will be able to use favorite version control system, make database releases in form of DACPAC and BACPAC packages, easily create upgrade scripts, do schema compare and so on. This is included in Visual Studio 2013 and available as separate free addon for Visual Studio 2010 and 2012 (so called SQL Server Data Tools). Definitely take your time to acquaint with it.

This is new, developer-oriented way of professional database development. SQL Server Management Studio is more administrative tool than a full blown developer tool.

like image 195
Endrju Avatar answered Sep 16 '22 16:09

Endrju