Geek asks and answers

Visual Studio 2012 SQL Database Project with SSDT

I'm starting to use Visual Studio 2012 with the built-in SQL Server data tools, and although I watched 2 microsoft videos when I started working with SQL databases, it’s still hard for me to understand how to work with them, especially since I'm new to db development .

Some questions:

  • What is the difference between importing a database or adding a link to a database?

  • What is the difference between the Server Explorer and the SQL Server Object Browser tabs? In one, I can view the database through localhost \ SQLEXPRESS.dbname, and the other through localdb \ Projects. At what point are they synchronized?

  • How to change the name of the target database in the project properties?

+5
source share
2

1) , . . , SSDT #, db, # . SSDT, db.

2) SQL Server SSDT - SQL, , .

3) ( /), .

, .

+12

SQL Server Object Explorer (SSOX) Server Explorer. : SSOX SSOX

, SSOX , Server Explorer ( ) - .

Jamiet

+3

More articles:


All Articles