Wednesday, March 21, 2012

MSDE or SQL 2005 Express?

Which one would you choose for a small application that needs to go in
production NOW? SQL 2005 Express is supposed to be the successor of MSDE
2000, but is it stable enough for production?
NOW - I would look at MSDE.
If you can wait until Nov 7th, you might consider SqlExpress.
SqlExpress seems quite stable, but I find it hard to justify going into
production with it when we are so close to the release date. Also, depending
on whether or not you are also running any v2.0 .NET apps, you could have
issues with similar but still different versions of the CLR. Lastly, do you
qualify for the Go Live License and does that license apply to SqlExpress or
only Visual Studo?
-Andrew
"JDG" <JDG@.discussions.microsoft.com> wrote in message
news:745B1A5C-F8B1-47C7-BD19-E1F254231D7B@.microsoft.com...
> Which one would you choose for a small application that needs to go in
> production NOW? SQL 2005 Express is supposed to be the successor of MSDE
> 2000, but is it stable enough for production?
>
|||Thanks Andrew. Three weeks sounds manageable... Is this a published date?
I've registered for the Go Live license, including SQLExpress.
"Andrew Robinson" wrote:

> NOW - I would look at MSDE.
> If you can wait until Nov 7th, you might consider SqlExpress.
> SqlExpress seems quite stable, but I find it hard to justify going into
> production with it when we are so close to the release date. Also, depending
> on whether or not you are also running any v2.0 .NET apps, you could have
> issues with similar but still different versions of the CLR. Lastly, do you
> qualify for the Go Live License and does that license apply to SqlExpress or
> only Visual Studo?
> -Andrew
>
> "JDG" <JDG@.discussions.microsoft.com> wrote in message
> news:745B1A5C-F8B1-47C7-BD19-E1F254231D7B@.microsoft.com...
>
>

No comments:

Post a Comment