Download - Using SQL Server Data Tools
![Page 1: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/1.jpg)
Using SSDTSQL Server Data
Tools@LynnLangit
![Page 2: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/2.jpg)
Data Expertise / Lynn Langit
Industry awards• Microsoft – MVP for SQL Server • Google – GDE for Cloud Platform• 10Gen – Master for MongoDBPracticing ArchitectTechnical author / trainer• Google Cloud Series• SQL Server Series • Cloudera certified Developer• 2 books on SQL Server BIFormer MSFT FTE• 4 years
![Page 3: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/3.jpg)
What is SSDT?
SSDT• SQL Server Data
Services• Part of Visual
Studio 2012
Set of services• SDLC• New “BIDS”• More
Integrated• Into Visual
Studio• Intro SSMS • Into Azure
![Page 4: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/4.jpg)
Can reduce common ‘pains’ for SDLC
• “will it work with SQL 2008?”
• “will it work with SQL Azure?”
• “if I change the table name what will break in the code?”
• “why are the report results are incorrect here?”
• “why doesn’t it work on production?”
Schema synchronizati
on
Data synchronizati
on
Edition & Version
targeting Refactoring
4
![Page 5: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/5.jpg)
SSDT Architecture
![Page 6: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/6.jpg)
About SQL Server Data Tools
Work with and on SQL Server and SQL Azure databases from within Visual Studio using activities and techniques familiar to developers
![Page 7: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/7.jpg)
Getting SQL Server Data Tools
![Page 8: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/8.jpg)
SSDT Tools for SQL Server 2012
• Core tools – included in VS 2012• BIDS download -
http://www.microsoft.com/en-us/download/details.aspx?id=36843
8
Visual Studio 2012 Visual Studio 2010
• Core Tools - download• BIDS download - download
June 2013 – updates - data compare, extensibility, build & deployment, new schema model API, deployment contributor extensibility, build contributor extensibility
![Page 9: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/9.jpg)
About DACPAC and BACPAC
Versioned container for database schema & more
To include data use a BACPAC
Designed to work with SQL Azure
9
![Page 10: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/10.jpg)
April 2013
DemoWorking with DACPAC in SSMS
![Page 11: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/11.jpg)
Details about DACfx
• Component for application lifecycle services for SQL Server and Windows Azure SQL Databases
• Supports deployment and management scenarios• Extracting/Exporting live database to DAC• Deploying DAC to new or existing database• Migrating from on-premise SQL Server to Windows Azure• Includes command line SqlPackage.exe to create .dacpac
and .bacpac• Requires Visual Studio 2012• Download both x86 and x64 versions if using x64 machine
11
![Page 12: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/12.jpg)
April 2013
DemoGetting SSDT
![Page 13: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/13.jpg)
SSDT in Visual Studio
New Explorer View in VSSQL Server Object Explorer
• Connect to SQL Azure• Connect to SQL Server• LocalDB
Can work online or offline
![Page 14: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/14.jpg)
April 2013
DemosUsing SSDT with SQL Server Using SSDT with SQL Azure
![Page 15: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/15.jpg)
New – Table Designer in Visual Studio
![Page 16: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/16.jpg)
Offline Projects – Visual Studio
New Project Type --Set Source connection--Set Target project--Set Import settings--Creates Off-line Project
![Page 17: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/17.jpg)
Add Database Reference
![Page 18: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/18.jpg)
SSDT Schema Compare
![Page 19: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/19.jpg)
Refactoring
• Find All Dependencies• Rename with Preview• Intellisense
![Page 20: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/20.jpg)
Code Analysis Settings
![Page 21: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/21.jpg)
Publishing
![Page 22: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/22.jpg)
Version Targeting
![Page 23: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/23.jpg)
SSDT is new ‘BIDS’
Create SSAS cubes (tabular and multi-dimensional)Create SSIS packagesCreate SSRS reports
23
![Page 24: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/24.jpg)
April 2013
DemoUsing SSDT for Business Intelligence
![Page 25: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/25.jpg)
Alternatives to SSDT
• Red Gate SQL Tools (SQL Compare, etc…)• TOAD for SQL Server• IDERA SQL Comparison toolset
25
![Page 26: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/26.jpg)
Try it out
Determine versions of SQL and VS
Download all parts of SSDT needed
Try out DACPACs from SSMS
Try out BI functionality
Read the SSDT team blog
![Page 27: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/27.jpg)
www.TeachingKidsProgramming.org• Free Courseware • Do a Recipe Teach a Kid (Ages 10 ++)• Java or Microsoft SmallBasic• C# on Pluralsight
• recipes)
![Page 28: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/28.jpg)
VOTECONFIRMSHARE
![Page 29: Using SQL Server Data Tools](https://reader036.vdocuments.us/reader036/viewer/2022062312/5554be71b4c90559398b4cdd/html5/thumbnails/29.jpg)
Keep Learning
Twitter: @LynnLangitYouTube:http://www.youtube.com/user/SoCalDevGal
Hire me• To help build your BI/Big Data
solution• To teach your team next gen BI• To learn more about using NoSQL
solutions