Re: REgarding SQL Server (express vs full)
Aqua Data studio should work fine as a front end. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334173 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: REgarding SQL Server (express vs full)
On 2010-05-31, at 23:49, Dave Watts wrote: > Without knowing any more than you've mentioned, I think you'd be fine > with Express as long as you conform to whatever its license > limitations happen to be. It doesn't come with a management console, > but if you don't need that you should be just fine. If by "management console" you mean SQL Server Management Studio, there is a free Express version. It's missing some features, like the ability to copy a database, but you can download it at http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en . I have quite a few clients who use SQL Server Express and as long as your database can run on 1 CPU, in < 1GB of RAM and is < 4GB in size it works great. For most intranet sites, these wouldn't be practical limitations. - Andrew. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334171 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: REgarding SQL Server (express vs full)
> I'm working on a project (intranet app) for a small business (15 to 20 > users). So Cost > of course is always a concern since this will be a full setup (hardware and > software). > What are the major differences people have found here between using MS > SQL Express and the full version of MS SQL? What do you recommend knowing > its only going to be used internal and a small user base. They only have 1 > non-web > app they are wanting to use that would utilize MS SQL. Without knowing any more than you've mentioned, I think you'd be fine with Express as long as you conform to whatever its license limitations happen to be. It doesn't come with a management console, but if you don't need that you should be just fine. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or ons ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334165 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: REgarding SQL Server (express vs full)
http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx If they aren't married to microsoft and cost is an issue, I'd recommend MySQL instead. On Mon, May 31, 2010 at 6:42 PM, Christopher Stowell wrote: > > Sorry if this is the wrong place, but with the knowledge this list has > > I'm working on a project (intranet app) for a small business (15 to 20 > users). So Cost of course is always a concern since this will be a full > setup (hardware and software). What are the major differences people have > found here between using MS > SQL Express and the full version of MS SQL? What do you recommend knowing > its only going to be used internal and a small user base. They only have 1 > non-web app they are wanting to use that would utilize MS ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334164 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm