|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Express - Cut features
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 Use task scheduler or Windows Synchronization manager instead of SQL Server
Agent. -- Show quoteHide quoteHilary 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 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 > > >
Other interesting topics
Sql Server 2005 Management Console Connect to Sql Server 2000?
Database Mirroring and Backup purge all history from msdb CPU maximums & multicore CPUs SQL Server 2000 Enterprise Edition - how to create named instance? Can not connect to SQL Server Transactional logs profiler dts scheduling Script to list Users with SA Role on the server |
|||||||||||||||||||||||