学习MSSQL2005笔记3--SQL2005版本和补丁
一、MSSQL2005版本。
SQL2005 分五个版本:
1.Enterprise(企业版): 只能安装在2000/2003 sever版本上,不支持XP.
2.Development(开发版): 可以安装到XP上,这个就足够了。 下载 3.Workgroup,(工作群版)
4.Standard,(标准版)
5.Express.(简易版):没有管理器Management Studio,支持内存较少,小型的应用程序可以使用它来安装数据库引擎。
每个版本都区分 X86 /X64,安装时注意选择。
二、补丁情况。
截至目前(2006.09.20),我收集到的补丁程序有:
1 SP1: X86 下载
2 SQL Server 2005 累积修补程序包(版本 2153)
注意安装顺序!
如果在基于 x86 的操作系统上运行 SQL Server 2005,则必须按照下列组件包出现的顺序安装它们:
SQL Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQL2005-KB918222-x86-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/sql2005-kb918222-x86-enu.exe)
Microsoft SQL Server 2005 Analysis Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/AS2005-KB918222-x86-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/as2005-kb918222-x86-enu.exe)
Microsoft SQL Server 2005 Integration Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/DTS2005-KB918222-x86-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/dts2005-kb918222-x86-enu.exe)
Microsoft SQL Server 2005 Notification Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/NS2005-KB918222-x86-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/ns2005-kb918222-x86-enu.exe)
Microsoft SQL Server 2005 Reporting Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/RS2005-KB918222-x86-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/rs2005-kb918222-x86-enu.exe)
SQL Server 2005 Tools
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQLTools2005-KB918222-x86-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/sqltools2005-kb918222-x86-enu.exe)
用于基于 x64 的操作系统的组件包
如果在基于 x64 的操作系统上运行 SQL Server 2005,则必须按照下列组件包出现的顺序安装它们:SQL Server 2005
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQL2005-KB918222-x64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/sql2005-kb918222-x64-enu.exe)
SQL Server 2005 Analysis Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/AS2005-KB918222-x64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/as2005-kb918222-x64-enu.exe)
SQL Server 2005 Integration Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/DTS2005-KB918222-x64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/dts2005-kb918222-x64-enu.exe)
SQL Server 2005 Notification Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/NS2005-KB918222-x64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/ns2005-kb918222-x64-enu.exe)
SQL Server 2005 Reporting Services
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/RS2005-KB918222-x64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/rs2005-kb918222-x64-enu.exe)
SQL Server 2005 Tools
http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/SQLTools2005-KB918222-x64-ENU.exe (http://download.microsoft.com/download/6/e/8/6e85f7ab-9f6c-4f3c-8f89-da0f78e026dc/sqltools2005-kb918222-x64-enu.exe)
三、SQL2005范例下载
参看fsxbear的BLOG的文章:安装SQL2005例子数据库
x86
- SqlServerSamples.msi -- 19,092 KB
- AdventureWorksDB.msi -- 27,992 KB (case-sensitive collation)
- AdventureWorksDBCI.msi -- 29,116 KB (case-insensitive collation)
- AdventureWorksBI.msi -- 7,592 KB (case-sensitive collation)
- AdventureWorksBICI.msi -- 8,814 KB (case-insensitive collation)
(本文内容根据网络资料整理)
posted on 2006-09-21 10:02 newman0816 阅读(2173) 评论(0) 编辑 收藏 举报