SQL Server 2008 Management Tools Basic vs Complete Explained....
来源:互联网 发布:算法设计与分析沙特pdf 编辑:程序博客网 时间:2024/05/21 09:55
SQL Server 2008 Management Tools Basic vs Complete Explained....
When you install SQL Server 2008 editions other than SQL Server 2008 Express, you are presented with a Feature Selection screen like the following:
Notice the Description window on the right I've circled. In this case I had selected the Feature called Management Tools - Basic. The Description window describes what is included with this feature, which is basically (no pun intended) SQL Server Management Studio (plus SQLCMD and Powershell support).
If you select the feature Management Tools - Complete, the description shows what additional features and tools are included in this feature selection.
Translation: Management Tools - Complete is as the name implies. You get it all. You can use SQL Server Management Studio with Object Explorer for Analysis Services, Integration Services, and Reporting Services. Plus you get other tools installed such as Database Tuning Advisor (DTA) and SQL Profiler.
So if you only want to install Management Studio to monitor and manage the Database Engine and want to reduce the amount of software installed on your machine, then just pick Management Tools - Basic. If you pick this option, but later "want it all", no problem. Just use the Add Feature "feature" of setup to add Management Tools - Complete (you can also remove the Complete feature if you decide later you don't want it).
So what is SQL Server Management Studio Basic as described in the advertisements for SQL Server 2008 Express on the download page?
http://www.microsoft.com/express/sql/download/default.aspx
Effectively it is the same features of Management Studio as though you had picked Management Tools - Basic on a standard installation of SQL Server 2008. But there are few twists due to the fact that you are installing SQL Server 2008 Express:
1) In Object Explorer you are not presented with the same options as you will see when you install the Management Tools - Basic feature in standard editions of SQL Server. This is because these options as features are not available in SQL Server 2008 Express. For example, consider the following screenshot of SQL Server Management Studio on a SQL Server 2008 Developer SKU with the Management Tools - Basic feature selected. Notice in Object Explorer, you can see features like Resource Governor, Data Collection, and Maintenance Plans.
Compare this with SQL Server 2008 Express with Advanced Services installed with the selection of the Management Tools - Basic feature (you don't get a Complete option):
Since features like Resource Governor are not available for SQL Server 2008 Express SKUs, we don't provide the graphical options to use or manage them.
This only occurs though with your connection to the SQL Express Server. On this machine, if I connect Object Explorer to a server that is say SQL Server Enterprise Edition, I will now get options that match that edition like the following screenshot:
The same is true if I tried to manage a SQL Express server from Management Studio with Enterprise Edition installed: In the Object Explorer tree for the SQL Server Express Server I would only get the options that apply to that edition.
2) If you use Management Studio with SQL Server 2008 Express and attempt to Enable Policy Management by right-clicking on its icon, you will get the following dialog box error:
This error occurs because policy based management automation is not available in SQL Server 2008 Express SKUs (mainly because we don't ship SQL Server Agent in Express). However, You can still create policies and evaluate them on-demand.
- SQL Server 2008 Management Tools Basic vs Complete Explained....
- Toad vs SQL Server Management Studio Express新功能
- SqlServer 2008 Management高级应用:Sql Prompt和SSMS Tools
- 安装sql server 2008 management studio express
- 安装sql server 2008 management studio express
- 安装SQL Server Management Studio 2008心得
- SQL Server Management Studio 2008 (ssms) 安装
- Sql Server 2008 Management studio安装教程
- sql server 2008 management studio安装教程
- 如何安装SQL server 2008 management studio
- SQL Server Management Studio
- SQL Server Management Studio
- About SQL and SQL-Based Management Tools
- About SQL and SQL-Based Management Tools
- About SQL and SQL-Based Management Tools
- Database SQL script automation management tools investigation
- SQL Server Management Studio 安装
- SQL Server Central Management System
- 最常用的update语法
- jquery ajax实例
- 使用 Hudson 进行持续集成(转载)
- 重定位编译文件
- AT命令详解
- SQL Server 2008 Management Tools Basic vs Complete Explained....
- java修改windows注册表设置程序自动运行
- MDX一些技巧
- 继续翻译:不在区分OIPF,CEA-2014,hbbtv
- “热”更新动态库(dll文件)
- 全面解析Java中的String数据类型
- 30+ 新鲜惊奇的 jQuery 插件与教程
- Primary Arithmetic
- DC与GC的区别