Install SQL Server 2019, Data tools etc.

SQL Server 2019 Installation

Download en_sql_server_2019_developer_x64_dvd_baea4195.iso file from MSDN Subscription.

Mount iso file to file system.

Run Setup.exe from the mounted CD-ROM.

Don't worry about the warning, just ensure the ports are open if you need remote access.

Now the installation is completed and ready to use.

Let's see other options in the installation

SSMS - SQL Server Management Studio

Download SQL Server Management Studio (SSMS)

SSAS,SSRS,SSIS

Install SSDT

Launch Visual Studio Installer

Install SSAS, SSRS Project Templates

Open Manage Extensions from Visual Studio menu.

Search for ssdt.

When you close Visual Studio the installation started automatically.

Install SSIS Project templates

Click on Download button, the linked browser will be open for download, or use this link to download Microsoft.DataTools.IntegrationServices.exe file.

https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

Done

Now open Visual Studio, the newly added project templates are shown in the list.

Author: IT Team