MSDE replacement SQL Server Express
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=11040
Printed Date: 30 March 2026 at 4:19am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: MSDE replacement SQL Server Express
Posted By: JohnKn
Subject: MSDE replacement SQL Server Express
Date 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:
Does that sound like SQL Express will be able to support more connections than MSDE currently does?
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. |
Replies:
Posted By: michael
Date 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. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: davidshq
Date 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. ------------- - http://www.davemackey.net/" rel="nofollow - Dave Mackey - Virtual Home. |
Posted By: JohnKn
Date 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! :) |
Posted By: Mart
Date 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 |
Posted By: davidshq
Date 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. ------------- - http://www.davemackey.net/" rel="nofollow - Dave Mackey - Virtual Home. |
Posted By: dpyers
Date 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. |