Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is SSDT only a client tool? Expand / Collapse
Author
Message
Posted Sunday, August 10, 2014 3:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, September 6, 2014 8:47 AM
Points: 8, Visits: 67
Sorry I'm a bit confused about SQL Server Data Tool (SSDT).

What I read on internet is this: "SQL Server Data Tools (SSDT) is a toolset which provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the SQL Server Object Explorer in VS to easily create or edit database objects and data, or execute queries."

But what is not clear to me is: if I haven't installed a SQL Server engine (e.g. SQL Server 2012), how to and where SSDT run/execute DDL/DML queries and store my .mdf file??

What I want ask to you is: Do SSDT is only a client tool or it provide also a server engine for run/execute DDL/DML queries and store my .mdf file??

thanks
Post #1601552
Posted Monday, August 11, 2014 3:42 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:46 AM
Points: 1,976, Visits: 3,280
It's a client tool. You provide connection information to it for an existing machine with SQL Engine installed on it.
Visaul Studio also keeps a LocalDB version which is only accessible to you through VS. I don't think that requires SQL Database Engine installed locally.
Post #1601740
Posted Monday, August 11, 2014 4:30 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:24 AM
Points: 13,731, Visits: 10,693
Gazareth (8/11/2014)
I don't think that requires SQL Database Engine installed locally.


Indeed, you can work with SSDT just fine without having SQL Server installed.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1601759
Posted Monday, August 11, 2014 4:45 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:46 AM
Points: 1,976, Visits: 3,280
Cheers Koen, thought that was the case.
Post #1601768
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse