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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |