I must release a new Db on 4/1 into an isolated small network (pier workgroup) and my choices are MSDE or Express. I'm new to both (MSDE yesterday, Express today). I am familiar with SQL Server and prefer using the tools with Express, but is it stable enough to use in this type of production environment?
I hope so. I also am going live with SQL Express 05 around April or May and it will be ran on 1-15 computer systems at a time.
Also, just to make it fun... we are still running a VB6 front end so we are using ADO 2.8.
I think it is ready. One way to find out. I'll post here if i come across something crazy.
Yep, I think it's stable enough, we went live a month ago with a shrink-wrapped product using SQL Express as the backend.
Thanks for the comments Matt & Scott.
SQL Express released in November 2005 and I have not heard anything to suggest that it isn't stable enought to use as you've all suggested. There is a new member of the "family" called SQL Express with Advanced Services that has just been released to CTP. That is pre-release software so it should not be used in production environments at this time.
Regards,
Mike Wachal - SQL Express team
