Welcome
description
Transcript of Welcome
2012 © Trivadis
BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN
Welcome
November 2012Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools
1
Effiziente Data Warehouse Entwicklung mit "SQL Server Data Tools for Visual Studio 2010"
November 2012Meinrad Weiss
2012 © Trivadis
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
November 2012
2Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools
2012 © Trivadis
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
November 2012
3Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools
2012 © Trivadis
Connected Model
November 2012Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools
4
SQL Server Data Tools
SQL Server
“Get Definition”
Deploy
TableView Proc Func …
2012 © Trivadis
Project Model
November 2012Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools
5
SQL Server Data Tools
SQL Server
Create Project Deploy
TableView Proc Func …
Table View
Proc FuncTable View
Proc Func
(LocalDB)
F5
.dacpacSnapshot
2012 © Trivadis
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
November 2012
6Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools
2012 © Trivadis
Application Project Integration
Multi-mode table editor GUI window
T-SQL window
Property window
Changes made in one window update in other windows
November 2012
7Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools
2012 © Trivadis
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
November 2012
8Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools
2012 © Trivadis
Schema compare
Detailed information of differences between two databases
Supports generation of delta scripts
November 2012Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools
9
2012 © Trivadis
BASEL BERN LAUSANNE ZÜRICH DÜSSELDORF FRANKFURT A.M. FREIBURG I.BR. HAMBURG MÜNCHEN STUTTGART WIEN
Let‘s go.
November 2012Effiziente Data Warehouse Entwicklung mit SQL Server Data Tools
10
Wettbewerb