Deborah's Developer MindScape






         Tips and Techniques for Web and .NET developers.

October 21, 2012

Adding a New Database with SSDT

No, SSDT is not a disease; it is a set of SQL Server Data Tools that are included as part of Visual Studio 2012. You can use the SQL Server Object Explorer from the SSDT to maintain or view your databases.

See this link for an introduction to SQL Server Object Explorer.

To create a new database in SQL Server Object Explorer:

1) Open the SQL Server Object Explorer toolbox using View | SQL Server Object Explorer from Visual Studio 2012.

2) Drill down to the Databases node.

3) Right-click and select Add New Database.

image

4) Visual Studio creates a database named "New Database" by default and provides an opportunity for you to change the name.

image

5) In this example, the database was named "Customer". Open the new database’s node to view the created folders.

image

You can then create tables, views, stored procedures, or whatever.

Use the SQL Server Object Explorer any time you need to create or maintain a database.

Enjoy!

2 Comments

  1.   JrT — March 24, 2013 @ 7:30 am    Reply

    Hi Debora.

    I have a few years using Sql Server in my projects and like in the oldest times I can’t live without SSMS. Is there any advantage or disadvantage not use SSMS instead of SSDT

  2.   DeborahK — July 31, 2013 @ 1:02 am    Reply

    Hi Jr T, the database project part of ssdt is where much of the differences are. My latest posts cover the new database project.

RSS feed for comments on this post. TrackBack URI

Leave a comment

© 2021 Deborah's Developer MindScape   Provided by WPMU DEV -The WordPress Experts   Hosted by Microsoft MVPs