Um outro ponto importante é que conforme já anunciado pela Microsoft, o MSDE 2000 não será suportado no Windows Vista (Running SQL Server on “Microsoft Windows Server Longhorn” or Microsoft Windows Vista). Sendo assim, se você está començando a desenvolver uma aplicação e pretende que ela tenha uma vida longa, considere já começar com o SQL Express.
O white paper cobre os seguintes tópicos:
Introduction 1
System Requirements for SQL Server 2005 Express 2
Feature Comparison of MSDE and SQL Server 2005 Express 3
Key advantages of SQL Server 2005 Express over MSDE 4
Increased maximum database size 4
No workload governor 4
SQL Server 2005 Management Studio Express Edition 5
CLR integration 6
New data types 7
User instance support 7
Reporting Services 7
SQL Service Broker 8
Full-text search 8
Enhanced security 8
MSDE features not included in SQL Server 2005 Express 9
Windows 9x support 9
DTS runtime 9
SQL Agent 9
Replication publication 10
Upgrading MSDE to SQL Server 2005 Express 10
Upgrade considerations 10
Number of MSDE instances 10
MSDE installation method 11
MSDE language 11
Performing an in-place upgrade 11
Verify the SQL Server 2005 Express installation 14
Performing a side-by-side upgrade 14
Upgrading MSDE to different editions of SQL Server 2005 16
Upgrading to SQL Server 2005 Workgroup Edition 18
Upgrading to SQL Server 2005 Standard Edition 19
Upgrading to SQL Server 2005 Enterprise Edition 19
Performing Configuration Changes 20
Enabling network protocols 20
Service accounts 21
Deploying SQL Server 2005 Express Applications 21
Command-line installation 22
ClickOnce deployment 23
Licensing 23
Conclusion 24
Para fazer o download do white paper, clique sobre o link Upgrading from MSDE to SQL Server Express white paper (formato .doc)
Se preferir, acesse também a versão web no link http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx