"Rob" <rob_nicholson@nospam_unforgettable.com> wrote in message
news:dTPZh.693$MH3.537@newsfe4-win.ntli.net...
>> Jeez - this is complex!!
>
> And it gets worse - just checked the MSDN downloads and there is:
>
> o SQL Server 2005 Everywhere edition - mobile use?
> o SQL Server 2005 Express Edition with advanced services - seems to
> include SSMS Express plus few other things
> o SQL Server 2005 Workgroup Edition - new one to me!
>
> Cheers, Rob.
>

> What's the difference between SQL 2005 Express (which gets installed
> with VS 2005 by default) and SQL 2005 Developer editions?

> Also, I miss the old SQL Enterprise manager and query analyser so I've
> installed SQL Server Management Studio Express. What does the Studio
> Express bit relate to? Is it that this version can only be used with SQL
> 2005 Express. The naming infers that the full SQL Server 2005 version
> has a more powerful management tool - is that correct?

> I'm trying to find a replacement for SQL Enterprise Manager (from SQL
> 2000) in which I can write an equivalent of a DTS package to transfer
> data from a SQL Server 2000 to SQL 2005 Express in a development
> environment.

> Fewer features. For instance SQL Agent is missing. There is a topic
> on this in Books Online.

> Yes, SSMS Express is a stripped down version of SSMS. Most of the
> features removed are support for things that are not in SQL Express.
> You can use SSMS Express with any edition of SQL Server, and you can
> use the real Mgmt Studio with SQL Express.

> You can also use good ol' Query Analyzer with SQL 2005, although some
> things may not work. Enterprise Manger does not work with SQL 2005.

> So that's one of the missing features. :-) DTS has in SQL 2000 been
> superceded by SQL Server Integration Services, SSIS. SSIS does not
> come with SQL Express. To do data import/export with SQL Express
> you will have to let it suffice with BCP.

> The tool to work with SSIS packages in SQL 2005, is Business Intelligence
> Development Studio, which lives in the Visual Studio shell.

> Jeez - this is complex!!

> Thanks - I'm tempted to roll my PC back and install SQL 2005 Developer
> before VS 2005. I assume that if there is already a SQL Server
> installed, VS 2005 won't install the Express version? Or do I have to do
> a custom install and deslect the option to install SQL Express 2005.

> Does SQL 2005 Developer have SSIS and can SSIS transfer data from a SQL
> 2000 server into SQL 2005 Developer?

> I think I will roll back. The SQL 2005 Developer DVD from MSDN actually
> installs VS 2005! I wasn't expecting that. No wonder it took a while. Must
> have been the options I chose. I prefer the full SSMS, it's more like good
> old Enterprise Manager :-)

"Rob" <rob_nicholson@nospam_unforgettable.com> wrote in message
news:1l9_h.1335$r4.1274@newsfe1-gui.ntli.net...
>> There is little need to uninstall VS once you have it. But installing
>> Developer Edition is a good idea. It's cheap, and if you have access
>> to it through MSDN, there is on extra cost at all. But keep Express.
>> Maybe you need something that looks like a production database on your
>> machine - that is Developer not licensed for.
>
> I've just built a virtual PC to check out the developer version. I've
> never really looked at SQL 2005 until now as our work systems are still in
> the SQL 2000 world and probably will be for some time to come.
>
> I think I will roll back. The SQL 2005 Developer DVD from MSDN actually
> installs VS 2005! I wasn't expecting that. No wonder it took a while. Must
> have been the options I chose. I prefer the full SSMS, it's more like good
> old Enterprise Manager :-)
>
> I assume I should install VS 2005 first without SQL Express and then
> install SQL 2005 Developer.
>
>> Developer Edition has all the features of Enterprise Edition. It's
>> just the licensing that is different.
>
> Similar to the SQL 2000 developer then.
>
> Cheers, Rob.
>