![]() 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.
0 Comments
Leave a Reply. |