Sql-server – What’s the difference between SQL Server Management Studio and the Express edition


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

Best Solution

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.