Please vote to include the BI project templates VS 2012

Question

Please vote to include the BI project templates in VS 2012

http://visualstudio.uservoice.com/forums/121579-visual-studio/suggestions/2203021-ensure-that-you-do-not-release-a-future-version-of

Answer 1

Hi GotNetDude1,

Thank you for posting on TechNet forum.

To create Business Intelligence (BI) projects, we need the Business Intelligence development Studio (BIDS) which is a component of SQL Server and shipped with SQL Server Editions. In SQL Server 2008 R2 and earlier versions, it is known as BIDS, and in SQL Server 2012, it is known as SQL Server Development Tool (SSDT). The BIDS or SSDT uses Visual Studio shell and can be fully integrated with Visual Studio. So, when both SQL Server and Visual Studio are installed on one computer, the BI project templates are integrated with the Visual Studio and we can create BI projects in Visual Studio. Please understand that the BIDS is a feature only provided by specific SQL Server Editions currently.

Meanwhile, you can also submit a product feedback at https://connect.microsoft.com/SQLServer/Feedback. Your feedback is valuable for us to improve our products and increase the level of service provided.

Additionally, I have changed the type of the thread to "General Discussion". If you have any concerns, please feel free to let me know.

Thanks for your understanding.

Regards,
Mike Yin 

TechNet Subscriber Support
If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

---

Mike Yin

TechNet Community Support

Answer 2

While the suggestion indicated by GotNetDude1 specifically names BIDS and SSRS, I think that the spirit of the request is to be able to maintain business intelligence reports and reporting services definitions in ongoing versions of Visual Studio.

I suggest that one of the major flaws in the release approach of BIDS/SSDT is that it is not closely tied to the IDE container (Visual Studio) that it uses.  This is evidenced by the fact that VS2010 was RTM in April 2010, while the corresponding BI feature was not made available until March 2012.  That is a gap of 23 months.

Additionally, over the last week I have installed VS2012, followed by SQL Server 2012.  My VS2010 installation does allow me to work with BIDS projects now, but these projects cannot be opened in VS2012, and I cannot find any way to create either a BIDS or SSDT project anywhere in VS2012.  Perhaps someone can explain why I can find no references to SSDT in VS2012 even though I have both SQL Server and Visual Studio installed on one computer, as Mike explains.

If the current approach does not change, I would not expect to be able to manage any business intelligence projects in VS2012 until the next release of SQL Server (2014? 2015?).

It is counterproductive for developers to have to maintain multiple versions of specific software because new versions do not allow all of the capabilities of older versions.

I've entered a SQL Server bug at https://connect.microsoft.com/SQLServer/feedback/details/759119/installing-sql-server-2012-developer-edition-does-not-install-a-bids-or-ssdt-project-capability-into-visual-studio-2012

---

--- Thanks from Thierry.