SSDT 2013 new database Project missing
This might be a trivial error in my setup but I cannot seem to find where I went wrong in stalling SSDT 2013 with SQl Server and having the open to create a new database template
please see image
what I expect to be in the list in a sql template with the option to create a new database project could someone tell me what i'm missing ?
Thanks in advance
For database projects you'll need to install a version of Visual Studio that supports it - in your case it looks like you ran the standalone SSDT-BI installer which installs SSIS, SSAS and SSRS templates. This doesn't include database project templates. What you need is to install one of the VS versions with support - there are 2 Express versions (Express for Web and Express for Windows Desktop) and 3 paid versions (Premium, Pro, Ultimate). Here is a quote from the SSDT blog post explaining this:
Visual Studio 2013 - VS 2013 now has SQL Server tooling built in and shipped as part of the core product. Database Projects, SQL tools (such as schema compare & data compare), and the online experiences through SSOX are all included with the RTM version. We have full project and SSOX support in VS Express for Web and Express for Windows Desktop, so we have discontinued our stand-alone integrated shell offering. We have a component update feed that will use VS Update to push notification to users. To manually check for updates, go to the Tools > Extensions and Updates... menu to open the dialog. We will continue to post announcements on our blog and forum that a release is available and what is included in that update.
- SQL - Continue running all SQL statements even after error
- opposite of "top" in sql server, without using order by, there are no keys/indices
- Getting log messages from an SSIS package executed with an SQL query
- Project fails to load due to missing SqlServer.targets file after upgrading to Visual Studio 2013
- How to remove a specific character from a string, only when it is the first or last character in the string.
- convert datetime to bigint
- How to fix the "system cannot find the file specified" error in ASP.NET MVC and SQL Server 2019
- How to get all auto generated foreign key names?
- Untrusted Certificate Error when connecting to SQL Server running in Docker from .NET 7 API in VS2022
- In a junction table, should I use a Primary key and a unique constraint, or a compound/composite key?
- Convert to ASCII char in SQL Server
- SQL transaction locks query weird behavior
- Update SQL with consecutive numbering
- Returning Continuous Months and Copying Values from the Previous Month
- Export stored procedure results as CSV (UTF 8 BOM format) to external server from SQL Server 2012
- SQL Server XML Data - How to insert if empty or update if not
- "Incorrect syntax near ')'." from cmd.ExecuteNonQuery();
- SQL Server - get next Friday in DATETIME
- Prevent Role with limited SELECT access discovering object names in Azure SQL or SQL Server
- What is the best way to create and populate a numbers table?
- How to preserve data comma ',' while exporting data from SQL Server to flat file (CSV) where column delimiter is ','
- SQL Selecting if "active" = true
- Delete partial dulicate rows - sql
- How to disable transactions for individual migrations in Flyway on SQL Server
- Why does a WHERE IN query on a uniqueidentifer column result in a "range seek" (greater than/less than)?
- Stored procedure to insert a new employee and return the newly created record (including the Id)
- Generating a histogram from column values in a database
- Get size of all tables in database
- How can I get the size in bytes of a table returned by a SQL query?
- Reading a table from SQL Server into a DataFrame using SQLAlchemy