How Express, Developer and Enterprise differ as remote connection tools

  • For using SSMS to connect to remote databases only, how do the different versions distinguish themselves? For example, if I use Express on my laptop, will I be left with few tools that Enterprise would have when connecting to back end SQL databases?

    Let's assume the back end databases use SQL Server 2008 Enterprise. I know hosting databases would be different between different versions. But I want to know about using the remote connection tool of SSMS and how it differs between the different versions.

  • If you only install Express you'll be missing server management tools like Profiler. Here is a good rundown:

    What does this Express Edition look like, anyhow? By Tibor Karaszi

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • If I needed Express database engine on a laptop and a full set of tools to manage remote Enterprise or Standard editions, I'd install Management Tools/Complete from the Enterprise\Standard edition first, then database engine from the Express install files.

    Dan

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply