Can SQL Server Data Tools be installed on a server?
On our current installation of SQL Server 2008 R2, we have created several SSIS jobs. SQL Server Business Intelligence Development Studio is installed on our database server and that is what we used to create the SSIS jobs.
We are now in the process of migrating to a new database server that is running Windows Server 2016 and SQL Server 2016. I understand that SQL Server Business Intelligence Development Studio has been replaced by SQL Server Data Tools, which we will now need to manage our existing SSIS jobs as well as create new ones.
Can SQL Server Data Tools be installed on our new server, along with Visual Studio, or do they have to be installed on my workstation?
You have to install SQL Server Integration Services on the instance and you can install the tools on the server as well. However, it's usually bad form to develop things locally on the server. Having the tools on the server just increase 1) support and 2) the security footprint. Less is usually better for servers. It's better to install the tools locally on the workstation(s) and do your development/support from there.
Yes You can, ideally not suggested
