First general availability (GA) release of SSDT for Visual Studio 2017 (15.5.0) has published.Now design and deploy SQL Server content type :Database Projects, Schema Compare, Data Compare, SQL Server Object Explorer and more in way like develop an application in Visual Studio.Analysis Services and Reporting Services BI project types is available in the VS2017 Gallery.

Developers can leverage SQL Server Data Tools (SSDT) included in all Visual Studio editions. Additionally on Visual Studio 2017, developers can leverage Redgate Data Tools. SQL Search is available in all editions, and SQL Prompt Core and ReadyRoll Core are available for VS 2017 Enterprise subscribers.

  • SQL Server Data Tools (SSDT) turns Visual Studio into a powerful development environment for SQL Server, Azure SQL Database and Azure SQL Data Warehouse. With SSDT, developers can visually design, build, debug, test, maintain, refactor, deploy, source control and enable continuous integration & continuous deployment for their databases with a declarative model that spans all the phases of database development. Developers can work offline with a database project, or directly with a connected database instance in Azure SQL Database, Azure SQL Data Warehouse, and SQL Server running on Windows, Linux, Docker and in Azure or any cloud.
  • With ReadyRoll Core, users can develop, source control, and safely automate deployments of database changes, alongside application changes. This means the same tools used for application development can be utilized for database development and deployment, and ensures a single source of truth for both application and database changes. ReadyRoll’s migrations-based approach gives developers more control over the end database deployment script and can be easily integrated into DevOps processes, such as continuous integration and continuous delivery.
  • With SQL Prompt Core users can increase productivity with advanced IntelliSense-style code completion in Visual Studio.
  • SQL Search allows users to quickly search for SQL objects across databases. Together, Redgate Data Tools help to ensure database development is not the bottleneck to continuously delivering value to end users.

Benefits of developing database with SSDT is you can easily integrate Application Lifecycle Management (ALM) practices to database development. You can develop and manage your database in source control such as Git, automate build with continuous integration and orchestrate releases with continuous deployment.  Details.

In this blog, we will walk through a series of end-to-end scenarios of continuous integration and deployment. After playing through these scenarios, you will have a complete build and deployment automation setup for your Azure SQL Database from where you can venture into more advanced techniques. For simplicity we will use Visual Studio Team Services and Azure

The Data Storage and Processing workload is optimized for DB developers, but SSDT is a recommended option in most other workloads including ASP.Net and Web Development. It’s a standalone web installation experience for SQL Server Database, Analysis Services, Reporting Services, and Integration Services projects in Visual Studio 2017 15.5 or later.

System requirements :

Windows 7 SP1, Windows 8.1 or Windows Server 2012 R2, Windows 10 or Windows Server 2016.

Available Languages - SSDT for VS 2017

This release of SSDT for VS 2017 can be installed in the following languages:

Chinese (People's Republic of China) | Chinese (Taiwan) | English (United States) | French |German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Supported SQL versions

Relational databases SQL Server 2005* - SQL Server 2017 Azure SQL Database Azure SQL Data Warehouse (supports queries only; database projects are not yet supported)

You can now download it free. Download Link

Installation Steps :

[gallery ids=”872,873,874,875,876,877” type=”rectangular”]

 

Start with Visual Studio 2017 :

Step 1 : Create New Project using Visual Studio 2017 .Select SQL Server > SQL Server Database Project.

v1

Step 2 : Now with the Project you can add database objects tables, View , User defined function,Stored Procedure etc as New items .

v2

Step 3 : All objects and script files can be addable

v3

Step 4 : It can be possible Write SQL statement and executable .

v4

Have a Nice Day !