1 / 10

Welcome

Welcome. Effiziente Data Warehouse Entwicklung mit "SQL Server Data Tools for Visual Studio 2010" November 2012 Meinrad Weiss. SQL Server Data Tools. Next evolution of Visual Studio based database development tools

dahlia
Télécharger la présentation

Welcome

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Welcome Effiziente Data Warehouse Entwicklung mit "SQL Server Data Tools for Visual Studio 2010" November 2012Meinrad Weiss Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools

  2. SQL Server Data Tools • Next evolution of Visual Studio based database development tools • Provides developers with a single tool to support database development needs • Most developers will not need to install SSMS • Free availability via Web Platform Installer Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools

  3. Choice of Development Models • Rich disconnected (project-based) development model • Code analysis • Dependency tracking • Refactoring • Intellisense • Connected model • Data-tier Application (DAC Fx) model • Script generation also possible Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools

  4. Connected Model SQL Server Data Tools “Get Definition” Deploy SQL Server Table … View Func Proc Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools

  5. F5 Project Model SQL Server Data Tools (LocalDB) Table View Table View Proc Func Proc Func Snapshot .dacpac Create Project Deploy SQL Server Table … View Func Proc Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools

  6. SQL Server OBJECT EXPLORER • Replaces the need for SSMS for most developers • Rich set of functionality similar to Object Explorer in SSMS • Create/Drop and manipulate database objects • Build and Debug use LocalDB • No need for server-based SQL Server installation on developer's machines Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools

  7. Application Project Integration • Multi-mode table editor • GUI window • T-SQL window • Property window • Changes made in one window update in other windows Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools

  8. Platform targeting • Single project can target multiple platforms • SQL Server versions • SQL Azure • Project build provides errors/warnings • Specific to target • No need to create and execute scripts to find issues Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools

  9. Schema compare • Detailed information of differences between two databases • Supports generation of delta scripts Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools

  10. Wettbewerb Let‘sgo. Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools

More Related