Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - MSDE replacement SQL Server Express
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

MSDE replacement SQL Server Express

 Post Reply Post Reply
Author
JohnKn View Drop Down
Groupie
Groupie


Joined: 22 March 2003
Status: Offline
Points: 46
Post Options Post Options   Thanks (0) Thanks(0)   Quote JohnKn Quote  Post ReplyReply Direct Link To This Post Topic: MSDE replacement SQL Server Express
    Posted: 29 June 2004 at 3:16pm
MS has released a beta of what will be replacing MSDE in 2005.
http://lab.msdn.microsoft.com/express/sql/
From the FAQ:
Quote
How is SQL Server Express different from MSDE?
SQL Server Express is an evolution of MSDE that continues to make the features and functionality of SQL Server technology widely available. SQL Server Express includes enhancements to setup and manageability to make it easier to use than MSDE. SQL Server Express also utilizes simpler and more scalable performance limits than MSDE, which managed throughput with a workload governor.


Does that sound like SQL Express will be able to support more connections than MSDE currently does?


Quote
How much does SQL Server Express cost?

SQL Server Express is free to use and redistribute. Please note that pre-release preview and beta software is for testing and evaluation purposes only, and should not be deployed for any other uses.


It also requires the .net framework 2.0 which is still in beta as well. There's a link to it from the download page for SQL Server Express. So far the tools it comes with don't appear to be any better than MSDE. The SQL Manager it installs is a fairly weak MMC plugin that doesn't appear to have any way to create or manage databases and so far I've been unable to connect to it using Enterprise Manager, so procede at your own risk.

As with any beta software, especially a server, I wouldn't suggest installing this on any machine you can't afford to format if things don't go well.


Edited by JohnKn
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 30 June 2004 at 11:05pm
But from what I read about SQL Express so far, is that it will be much better then MSDE, so I am definately looking forward to it.
Back to Top
davidshq View Drop Down
Senior Member
Senior Member


Joined: 29 July 2003
Location: United States
Status: Offline
Points: 299
Post Options Post Options   Thanks (0) Thanks(0)   Quote davidshq Quote  Post ReplyReply Direct Link To This Post Posted: 19 July 2004 at 1:49pm

I'd have to agree with Michael. I recently read an article on it in a techie paper (forget which one) which stated that SQL Express will have several large advantages over MSDE.
Respectfully,
David.

Back to Top
JohnKn View Drop Down
Groupie
Groupie


Joined: 22 March 2003
Status: Offline
Points: 46
Post Options Post Options   Thanks (0) Thanks(0)   Quote JohnKn Quote  Post ReplyReply Direct Link To This Post Posted: 19 July 2004 at 1:53pm
Time will tell, released products rarely match MS white papers written about what they're supposed to do though. It may have some advantages over MSDE but they won't give it to many features or scalability or they'll risk losing SQL server sales.

I hope it is better than MSDE, although I haven't really had any problems with the limited use I've done with MSDE so far, but I'm not betting on it being a major improvement. Here's hoping I'm just being cynically wrong! :)
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 19 July 2004 at 2:19pm
All of the Express products look very good. However, be cautious on what pc you install it on - I had to format one of mine because Web Developer express mucked it up
Back to Top
davidshq View Drop Down
Senior Member
Senior Member


Joined: 29 July 2003
Location: United States
Status: Offline
Points: 299
Post Options Post Options   Thanks (0) Thanks(0)   Quote davidshq Quote  Post ReplyReply Direct Link To This Post Posted: 19 July 2004 at 2:24pm

Thanks for the warning Mart. I was going to install the Web Developer Express but when I saw that it was only for testing purposes...I figured I wouldn't. I like the idea of free or cheap web development versions but don't really want to test it if I can't use my creations. :-( In any case, was going to install it on my main business computer, good warning.

Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post Posted: 19 July 2004 at 2:28pm

I replaced some Access/Jet LAN apps with Access/MSDE and was very pleased with it from a performance viewpoint, but deploymnet was a bear. No way to package it up nicely like Aceess/Jet.

The current MSDE is supported by Enterprise Manager and MS's MSQL manager web app. Does anyone know igf the new version will be as well?


Lead me not into temptation... I know the short cut, follow me.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.