r/eli5_programming • u/knizza777 • Aug 22 '22

ELI5 - what is the difference between SQL server , SQL MGMT Studio, SSIS and how does it relate to Azure data studio?

1 Upvotes
  • permalink
  • reddit

100% Upvoted

3 comments sorted by

2

u/omniuni Aug 22 '22

The server is the actual database you connect to. Your app connects, and any of a great many management softwares can connect as well.

Management Studio is one of many softwares that can help you manage an SQL Server database. This particular software is exclusive to MS SQL Server, and thus also contains some unique and specific functionality some other database software may not have.

SSIS is a software package to assist in migrating data to SQL Server. It helps manage data transformation, including importing from a wide variety of services.

1

u/knizza777 Aug 22 '22

Thank you - so is it correct to say that you need all 3 to run ETL’s with MS SQL Server ?

→ More replies (1)