With SQL Server 2012 Business Intelligence Development Studio is replaced with SQL Server Data Tools.
BIDS = Business Intelligence Development Studio
SSDT = SQL Server Data Tools (http://msdn.com/data/tools.aspx)
If you customize SQL Reporting Services reports for SCCM 2007 or ConfigMgr 2012 in you’ll probably want some GUI tool to help you edit or design the report. Microsft ReportBuilder 2.0/3.0 is quasi built-in to Reporting Services and allows creating and editing of RDL files in a limited manner. If you need a powerful tool to create a complex report you’ll likely turn to BIDS. However, BIDS is now depricated and beginning with SQL 2012 SSDT is the tool going forward.
SSDT utilizs the Microsoft Visual Studio 2010 SP1 or 2012 Shell which is very nice.
A word of caution: It appears that SSDT comes in several flavors and not all support Reporting Services. Be sure to install SQL Server Data Tools from the SQL Server 2012 SP1 install soruce and NOT the stand-alone / downloadable installer.
Some useful links:
- SQL Server Data Tools (SSDT) on MSDN: http://msdn.microsoft.com/en-us/library/hh272686(v=vs.103).aspx
- FAQ: Microsoft SQL Server Data Tools: http://msdn.microsoft.com/en-us/data/hh322942
- Get started developing with SQL Server Data Tools: http://msdn.microsoft.com/en-us/data/hh297027
- SSDT – What’s in a name?: http://sqlblog.com/blogs/jamie_thomson/archive/2012/04/03/ssdt-what-s-in-a-name.aspx
Install SQL Server Data Tools: http://msdn.microsoft.com/en-us/library/hh500335(v=vs.103).aspx Installing SQL Server Data Tools (SSDT): http://www.codeproject.com/Articles/451750/Installing-SQL-Server-Data-Tools-SSDT
Chad March 1, 2013