Home All Groups Group Topic Archive Search About

SQL Express - Cut features



Author
19 Jan 2006 2:57 AM
Joseph Hanna
The SQL Server 2005 range looks absolutely fantastic.  I can't wait to
leverage some of the new features...  but I'll have to.

Many of my clients are using MSDE 2000.  It has served them well and it is
just the right price.  Some have several machines on the network running a
local copy, replicating back to a master.  Others run a single instance on a
server.  Many have also outgrown MSDE and naturally progressed to the full
server - no problem.

In all solutions, I am making heavy use of the SQL Agent.  The MSDE
replacement is SQL Express, and it does not come with an Agent!  As a
byproduct, it cannot support Replication Publication.  DTS is another useful
feature that was cut, but this is not a huge problem for me.  I use SQL Agent
extensively to perform cleanup operations, backups and other system updates
at night.  How is this supposed to happen now?

How are we supposed to upgrade to the latest version if we are going
backwards?  The only option for moving to SQL Server 2005 is to at least
start at the Worgroup Edition at a cost of nearly AUD$1,000 for 5 users!

MS - Why do these things happen?   You encourage us to support you and stay
with your product, but you keep breaking our upgrade paths!  I am not into
Microsoft bashing.  I have been a loyal developer for over 10 years.  I think
MS have superior products, particularly developer tools.  I am only asking
you cut us a break and don't take things away from us.

Please put the SQL Agent back in SQL Express so we can move on from MSDE...

Joe

Author
19 Jan 2006 3:43 AM
Hilary Cotter
Use task scheduler or Windows Synchronization manager instead of SQL Server
Agent.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Show quoteHide quote
"Joseph Hanna" <joe.hanna@no.spam.vantageit.com.au> wrote in message
news:9D012E3B-206E-44BA-8C85-9FD1A68B76D0@microsoft.com...
> The SQL Server 2005 range looks absolutely fantastic.  I can't wait to
> leverage some of the new features...  but I'll have to.
>
> Many of my clients are using MSDE 2000.  It has served them well and it is
> just the right price.  Some have several machines on the network running a
> local copy, replicating back to a master.  Others run a single instance on
> a
> server.  Many have also outgrown MSDE and naturally progressed to the full
> server - no problem.
>
> In all solutions, I am making heavy use of the SQL Agent.  The MSDE
> replacement is SQL Express, and it does not come with an Agent!  As a
> byproduct, it cannot support Replication Publication.  DTS is another
> useful
> feature that was cut, but this is not a huge problem for me.  I use SQL
> Agent
> extensively to perform cleanup operations, backups and other system
> updates
> at night.  How is this supposed to happen now?
>
> How are we supposed to upgrade to the latest version if we are going
> backwards?  The only option for moving to SQL Server 2005 is to at least
> start at the Worgroup Edition at a cost of nearly AUD$1,000 for 5 users!
>
> MS - Why do these things happen?   You encourage us to support you and
> stay
> with your product, but you keep breaking our upgrade paths!  I am not into
> Microsoft bashing.  I have been a loyal developer for over 10 years.  I
> think
> MS have superior products, particularly developer tools.  I am only asking
> you cut us a break and don't take things away from us.
>
> Please put the SQL Agent back in SQL Express so we can move on from
> MSDE...
>
> Joe
Are all your drivers up to date? click for free checkup

Author
19 Jan 2006 4:07 AM
Joseph Hanna
The point is that they have taken some key functionality out of a product and
forced us to do extra work to replace it or pay for the larger edition.   The
Windows Task Scheduler does not have the inbuilt depencies of executing
subsequent tasks only if its predecessor were sucessful.  How much work will
have to go into building a utility to replace this so that can be run under
the Windows Scheduler?

It is not like they have removed the Agent completely from the SQL Server
range, they just chose to turn it off for the Express edition.


Show quoteHide quote
"Hilary Cotter" wrote:

> Use task scheduler or Windows Synchronization manager instead of SQL Server
> Agent.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Joseph Hanna" <joe.hanna@no.spam.vantageit.com.au> wrote in message
> news:9D012E3B-206E-44BA-8C85-9FD1A68B76D0@microsoft.com...
> > The SQL Server 2005 range looks absolutely fantastic.  I can't wait to
> > leverage some of the new features...  but I'll have to.
> >
> > Many of my clients are using MSDE 2000.  It has served them well and it is
> > just the right price.  Some have several machines on the network running a
> > local copy, replicating back to a master.  Others run a single instance on
> > a
> > server.  Many have also outgrown MSDE and naturally progressed to the full
> > server - no problem.
> >
> > In all solutions, I am making heavy use of the SQL Agent.  The MSDE
> > replacement is SQL Express, and it does not come with an Agent!  As a
> > byproduct, it cannot support Replication Publication.  DTS is another
> > useful
> > feature that was cut, but this is not a huge problem for me.  I use SQL
> > Agent
> > extensively to perform cleanup operations, backups and other system
> > updates
> > at night.  How is this supposed to happen now?
> >
> > How are we supposed to upgrade to the latest version if we are going
> > backwards?  The only option for moving to SQL Server 2005 is to at least
> > start at the Worgroup Edition at a cost of nearly AUD$1,000 for 5 users!
> >
> > MS - Why do these things happen?   You encourage us to support you and
> > stay
> > with your product, but you keep breaking our upgrade paths!  I am not into
> > Microsoft bashing.  I have been a loyal developer for over 10 years.  I
> > think
> > MS have superior products, particularly developer tools.  I am only asking
> > you cut us a break and don't take things away from us.
> >
> > Please put the SQL Agent back in SQL Express so we can move on from
> > MSDE...
> >
> > Joe
>
>
>

Bookmark and Share