Here is a complete feature matrix. http://msdn.microsoft.com/en-us/library/cc645993.aspx
I'm sure I used SSIS with 2005 Express, so I would expect it is with 2008. You certainly have import/export services anyway. Just make sure you get SQL Server Express with Tools. If you find features missing from the Management Studio express, there is a little cheat, you can download the FULL EDITION trial of SQL Server 2008 with tools, and get the full edition of Management Studio, which i'm pretty sure never expires, at least it didn't with 2005. The learning curve will be with using the new Management Studio rather than Enterprise manager, although I believe you can still use enterprise manager up to a point. Other than that your database will work the same unless you choose to learn and implement and of the new features. 2008 is miles apart from 2000. On Wed, May 11, 2011 at 3:52 PM, Jenny Gavin-Wear < jenn...@fasttrackonline.co.uk> wrote: > > Will, I pinched some of Gerald's popcorn and had a good read, thanks for > all > the replies. It has been very interesting reading the discussion on the > various DB's. > > Overall, SQL Server Express is coming out on top for me. My existing > databases don't get anywhere near the 10GB limit, and I wouldn't have any > issues transfering my existing code straight across, apart from one issue. > I read that SQL 2008 Express does not include DTS/SSIS, can anyone confirm > that please? > > Are there any other limitations / pitfalls of using SQL 2008 Express? I'm > also wondering if there is much of a learning curve, not so much as for new > features in 2008, but just in supporting my existing databases? > > I will need to run SQL 2008 Express alongside SQL 2000 on the same server > while I port everything across. Any issues I might encounter? > > Many thanks, > > Jenny Gavin-Wear > Fast Track Online > Tel: 01262 602013 > http://www.fasttrackonline.co.uk/ > > > > > No virus found in this outgoing message. > Checked by AVG - www.avg.com > Version: 9.0.900 / Virus Database: 271.1.1/3629 - Release Date: 05/10/11 > 19:34:00 > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:344451 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
