This way, SQL Server competed with other ETL products on the market. Business Intelligence Development Studio (BIDS) – an enhanced version of DTS Designer with many features on the ETL platform.SQL Server Management Studio (SSMS) – a single client tool with all features available across Query Analyzer and Enterprise Manager and several other new features.SQL Server 2005 enhanced all the above Client tools with more features and renamed them as below: It allows the users to create DTS packages and execute them via SQL Server jobs.

DTS Designer – the first basic interface to perform ETL operations.Also, it can restart SQL Server services, import and export data across SQL Server instances, create SQL Server jobs and execute them on a scheduled basis, and create Linked Servers.

Enterprise Manager – to manage SQL Server Instances and perform Backup/Restore operations.Besides, the tool has the Object Browser and the Scripting option to script out objects. Query Analyzer – to connect to SQL Server instances and execute queries on SQL Server instances.SQL Server 2000 offered several Client tools for users to connect to SQL Server instances and perform certain activities.

In this article, we will go through various Client Tools offered by SQL Server itself and learn about SQL Server Data Tools and its hidden potentials to make the lives of DBAs and Developers easier. Any SQL Server DBA, Developer, or end-user always needs a client tool to connect to SQL Server and access its features.

Ssdt install visual studio 2017