SQL Server Management Studio 和 Express 版之间有什么区别? [英] What's the difference between SQL Server Management Studio and the Express edition?

问题描述

我目前正在使用 Express.完整版可以获得哪些额外功能?

解决方案

Management Studio 中没有区别.不同之处在于数据库引擎限制！引擎是相同的，但它会拒绝您的某些功能.

快速版中的导入/导出向导可在以下位置找到:C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

如果您没有，请从 Microsoft 下载:http://go.microsoft.com/fwlink/?LinkId=65111>

您可以安装 Microsoft SQL Server 2005 速成版工具包，以获得很酷的玩具，如导入/导出向导和报告.

探查器不是 Management Studio 的一部分.它是 SQL Server 完整版附带的另一个应用程序.即使您安装了它，您的 Express Edition 服务器引擎也将拒绝使用它.

I'm using Express currently. What extra features do I get with the full edition?

解决方案

There are no differences in Management Studio. The differences are in the database engine LIMITATIONS! The engine is the same but it will deny you some features.

Import/Export wizard in the express edition can be found at: C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe

If you dont have it, dowload it from Microsoft: http://go.microsoft.com/fwlink/?LinkId=65111

You could install the Microsoft SQL Server 2005 Express Edition Toolkit to get the cool toys, like the Import/Export wizard and the reports.

The profiler is not part of Management Studio. It is one more application that comes with the full version of the SQL Server. Even if you have it installed your express edition server engine will refuse to work with it.

这篇关于SQL Server Management Studio 和 Express 版之间有什么区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！