Freigeben über

If your app uses MSDE and you want it to run on Vista... UPGRADE to SQL Server Express

  • Artikel

I'm sure you will hear this many times in the coming days.  If you are a software developer writing code for internal use or resale, and you are using MSDE as your database engine, it is time to upgrade.

SQL Server 2005 Express Edition is the newer version of MSDE and has many advantages.  You get a management tool, reporting services, and a larger database size among other things.  It is not difficult to upgrade. 

MSDE is not dead.  MS will continue to support it for a little while longer... just not on new versions of the OS.  So if your users are staying on XP Pro, you are fine, in a way.  Someday, your users will call up Dell or HP and order a PC, and it will have Vista on it.  Why wait?

Check it out. Benefits of Upgrading MSDE to SQL Server 2005 Express Edition

[update 8/5/06] Alas, I find that I am not the correct person to be sharing this kind of news. I was rather expecting this news to be posted in more places, so that I could add a long list of links at this time. I can share a long list of other blog sites that have discussed the issue. There is a Microsoft blog that has attempted to create a better impression, so I'll add a link to Eric Nelson's blog. If you'd like more information on the decision not to extend support for MSDE to the Vista operating system, please start there. 

One further note: MSDE does run on Vista. However, there is no support for it and new installations will not be legally OK after 2007. Personally, asking a software vendor who has been shipping a seven-year-old free database engine to move up to one that is 100% compatible, better, faster, and easier to install, includes tools that the original one was missing, and is also free is not asking that much. The biggest hit will be on corporations who spent money writing apps on MSDE.

Comments

  • Anonymous
    August 03, 2006
    Does this mean MSDE won't work on Vista? or that you won't be able to get support from MS for running MSDE on Vista?
  • Anonymous
    August 03, 2006
    I'll bet anything that when Vista ships you'll have several products still using MSDE. Are there any valid reasons for not supporting MSDE on Vista?
  • Anonymous
    August 04, 2006
    The comment has been removed
  • Anonymous
    August 05, 2006
    Don't forget that u need to upgrade to the SQLExpress SP1, because pure express doesn't work on Vista