SSDT 2013 new database missing
It might be a trivial error in my setup, but I can't find where I went wrong, how to stop SSDT 2013 with SQl Server and open to create a new database template
see picture
what i expect to be listed in sql template with the ability to create a new database project can someone tell me what i am missing?
Thank you in advance
source to share
For database projects, you need to install a version of Visual Studio that supports it - in your case, it looks like you ran the SSDT-BI offline installer that installs the SSIS, SSAS, and SSRS templates. This does not include database project templates. You need to install one of the supported versions of VS - there are 2 Express versions (Express for Web and Express for Windows Desktop) and 3 paid versions (Premium, Pro, Ultimate). Here's a quote from SSDT's post explaining this:
Visual Studio 2013 - VS 2013 now has SQL Server instrumentation built in and shipped as part of the core product. Database designs, SQL tools (such as schema comparison and data mapping) and online experiences via SSOX are included in the RTM version. We have full project and SSOX support in VS Express for Web and Express for Windows Desktop, so we discontinued our standalone integrated shell offering. We have a component update feed that VS Update will use to push notifications to users. To manually check for updates, go to Tools> Extensions and Updates ... to open a dialog box. We will continue to post announcements on our blog and forum about the release's release and what's included in this update.
source to share