To set the scene, I maintain 4 local SQL Server 2008 R2 instances. At some point in the near future, 3 of these will be upgraded to SQL Server 2017 and migrated to azure.
I am currently using SSMS and SSIS 10.5 to manage these servers and develop ETLs.
Can SSMS 10.5 and 17.7 be run side-by-side, and can I do this before we've even upgraded any of the instances to 2017? Is there any benefit of doing so? I'm considering forking out for ApexSQL but some of the tools aren't compatible with 10.5.
Can SSDT also be installed side-by-side with SSIS 10.5?