We are running SQL Server 2012 SP1 Enterprise Edition on Windows Server 2008 R2 Enterprise SP1. We have Microsoft Visual Studio 2010 and SQL Server Data Tools installed on this same database server. My question is, how can we get Visual Studio 2010 and/or SQL Server Data Tools installed on a developer's machine or laptop? Are these two components (VS 2010 and SSDT) part of the SQL Server Install CD? Or SQL Management Studio Install CD? Or can these components be downloaded and installed for free?
We want our developers to be able to create SSIS Packages and Reports from their machines or laptops. Do both components (VS 2010 and SSDT) need to be install or just one? It appears they provide the same thing. (The developers already have SQL Server Management Studio installed on their machines.)
Thanks, Kevin