Deborah's Developer MindScape






         Tips and Techniques for Web and .NET developers.

Archive for August, 2013

August 12, 2013

Transaction-SQL Editor

The Transact-SQL Editor option in Visual Studio 2012 allows you to query your database directly from Visual Studio. It is part of the SQL Server Data Tools (SSDT) provided in Visual Studio. See this prior post for more information on SSDT. With the Transact-SQL Editor option, you can connect to any running SQL Server instance. […]

August 8, 2013

SSDT Data Compare

Visual Studio 2010 had a data compare feature that was removed in Visual Studio 2012, which drew much criticism. Now its back! If you don’t see the Data Compare option in the SQL menu of Visual Studio, see this prior post to get the update. See this prior post for more information on SSDT. Use […]

August 7, 2013

SSDT Schema Compare

As part of the Visual Studio SQL Server Data Tools (SSDT), the Schema Compare option compares the structure of the database tables, stored procedures, views, and other database objects. It shows you how two data sources are the same and how they are different. See this prior post for more information on SSDT. Use the […]

SSDT SQL Menu Options

The SQL Server Data Tools (SSDT) in Visual Studio include features in three areas of Visual Studio: SQL Server Object Explorer SQL Server Database Projects SQL Menu options Later posts cover the key options in the Visual Studio SQL menu: Schema Compare Data Compare Transact-SQL Editor But arguably the most important SQL menu option is: […]

August 6, 2013

Publishing Your Data Scripts

An earlier post detailed how to publish the schema and stored procedure scripts in your SQL Server Database Project. Two other recent posts (one using Insert statements and the other the Merge command) covered how to add a reference data script to your database project. But just adding the reference data script to the database […]

August 5, 2013

Creating a Merge Script for your Reference Data

When you create a database project data script using the SQL Server Object Explorer, it provides a set of SQL Insert statements. So it requires that you delete all of the existing table data and insert the new rows. But what if you don’t want to delete all of the existing data? That is where […]

Scripting Reference Data with SQL Server Object Explorer

Database projects are great for scripting the tables and stored procedures for a database, but what about data? There are often times that you need to pre-populate tables with reference data. See this link for an introduction to SQL Server Object Explorer. See this link for an introduction to the 2012 SQL Server Database Projects. […]

August 2, 2013

Database Projects and Refactoring

There are often times that you need to update a database schema. But if that database is already in production, some changes, such as simply changing a column name, are difficult because of the potential data loss. For an introduction to Database Projects in Visual Studio 2012, please see this post. Let’s look at an […]

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