>>Also, unlike MSDE, it has a Management Studio application and no throttling on the number of
concurrent users! The only real constraint is a 4GB (I think) max database size.<<
Another constraint to consider when moving from MSDE to SQL Server 2005 Express is the SQL Agent no
longer gets shipped so you lose the built in scheduler.
Rick
White Light Computing, Inc.
www.whitelightcomputing.com
www.rickschummer.com
586.254.2530 - office
586.254.2539 - fax
-----Original Message-----
From: profoxtech-bounces at leafe DOT com [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke
Sent: Wednesday, January 31, 2007 12:08 PM
To: profoxtech at leafe DOT com
Subject: Re: What do I use in place of MSDE?
Vince Teachout wrote:
> I'm having a brain-fart morning here. I know that MSDE is pretty much
> obsolete, but I need to test VFP code on a MSSQL server backend. What
> should I be using instead, and where do I get it. Someone actually
> told me last week, but hey, that was a whole week ago? MSSQL
> developers version, or something like that? Thanks.
>
SQL Server 2005 Express Edition.
http://msdn.microsoft.com/vstudio/express/sql/register/default.aspx
Also, unlike MSDE, it has a Management Studio application and no throttling on the number of
concurrent users! The only real constraint is a 4GB (I think) max database size.
[excessive quoting removed by server]
©2007 Rick Schummer |
