瀏覽單個文章
ToastedIceCream
Silent Member
 

加入日期: Sep 2003
文章: 0
在網路上找了一下, 看來在SQL Server 2008 或更早的版本裡, SSMS Express 跟 Enterprise/Standand 版本是不一樣的.
我覺得要看你的程式設計師需要什麼的功能, 如果只是基本的讀資料, Expres 版本應該就夠了

如果他需要用工具來Debug (像是 deadlock 問題), 或是 performance tuning, 或是管理Enterprise SQL server 的 Analysis/Integration/Reporting Services, 那需要看SSMSE 的版本.

以下是Reference:

1) 像是在2005/2008 版本裡, Express 沒有 Profiler - 可以讓工程師作觀察SQL server 的運作

Microsoft 的解釋:
-------------------------
For SQL Server 2008 R2:
http://msdn.microsoft.com/en-us/library/ms365247(v=sql.105).aspx
- SSMSE cannot manage Analysis Services, Integration Services, or Reporting Services.
- You cannot update the full-text catalog by using SSMSE. You can use sqlcmd utility or Windows Scheduler to update the full-text catalog.
- SSMSE does not support scheduling administrative tasks by using SQL Server Agent.
- .. etc


討論區 Reference
-------------
What's the difference between SQL Server Management Studio and the Express edition?
http://stackoverflow.com/questions/...e-express-editi

Is SQL Server 2008 Management Studio Express the same as Standard?
http://stackoverflow.com/questions/...ame-as-standard

2) 以下是關於在2012 的版本

討論區 Reference
---------------------------
Is SQL Server 2012 Management Studio “Express” any different?
http://dba.stackexchange.com/questi...s-any-different

Microsoft 的解釋:
------------------------
http://msdn.microsoft.com/en-us/evalcenter/hh230763
- Express with Advanced Services (contains the database engine, Express Tools, Reporting Services, and Full Text Search)
舊 2012-11-30, 01:38 AM #8
回應時引用此文章
ToastedIceCream離線中