When you install the SQL Server management studio and then you want to connect with the SQL Server then there are four types of SQL servers are there, and what is the work of that four types of SQL servers. when we have to use that server. let's see what are they:-
- Database Engine
- Analysis Services
- Reporting Services
- Integration Services
- Database Engine:- It is a core component of the database engine here core means the main component of the SQL Server management studio. there are have some purposes to use this database engine. the first purpose is to store the data or table which means rows and columns. the second one is processing means after storing the data we have to perform some operations like insert, delete, update. and the third one is security means to provide security to our data.
- Analysis Services:- It is an MSBI Tool (business intelligence management tool) and we have to use this tool in the data warehousing for the data storing purpose. Analysis services have to convert the data from 2D( two dimensional ) or tables (rows & columns) to the 3D(three dimensional) formate means graphical formate.
- Reporting Services:- It is also called MSBI Tool or SSRS (SQL Server reporting services).reporting services to store the report or document about the company businesses. To use the reporting services can export the data from database engine to the other platform like (MS Word, MS Excel), etc. When you need to export the data from a database to another platform you can use reporting services.
- Integration Services:- It is also called MSBI Tool or SSIS (SQL Server integration services). Integration services are used to converting database tables for another database understandable format. This means if you are working in SQL Server database and then you want to convert into another database like the oracle at that time use the integration services.
