Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This section describes features provided by SQL Server Data Tools for designing and querying a connected database.
Using the SQL Server Object Explorer in Visual Studio, developers can now create, edit and browse database objects located in either an on-premise database server, such as SQL Server 2008 or Microsoft SQL Server 2012, or off-premise in SQL Azure. Developers can easily clone an existing production database to a test instance, perform additional development work on it, and publish the changes back to the production database.
Note
How To topics in this section contain a series of tasks that can be completed in a sequence.
In This Section
Topic |
Description |
|---|---|
Connect to a database and browse its entities. |
|
Use the new Table Designer to design tables and manage table relationships. |
|
Update a connected database without writing ALTER scripts. |
|
Specify which data should display in the Data View. |
|
Use Transact-SQL Editor to edit and execute Transact-SQL scripts. |
|
Write Transact-SQL scripts to edit the definition of a table, or populate data. |
|
Use the Data Editor to view or enter data in a table. |
|
Rename or delete database entities, and let SQL Server Data Tools automatically resolve object dependencies. |
|
Create a development database from a production database. |
|
Shows how to extract and publish .dacpac files. |