Nâng cấp SQL Server

[Henri]

Mình muốn nâng cấp từ SQL Server 2000 lên SQL Server 2005.
:catgoal:
Giúp minh với.
Cám ơn nhiều!!!


------------------------------------------------------------------
:bye:

[tumickey]

thì remove cai cũ cài cài mới :D

uhm cái khó là database cũ .
bạn có thế nói rõ là bạn chỉ nâng cấp SQL Server hay còn gì nữa ko . Mới biết đường mà F1 chứ :D

[Henri]

Tất nhiên thì mình có thể xóa cái cũ và cài cái mới.
Nhưng do mình có nhu cầu nâng cấp (chỉ nâng cấp thôi, không cần database cũ trong SQL Server 2000 nữa).
Mong bạn giúp đỡ.

[tumickey]

đọc http://msdn2.microsoft.com/en-us/library/ms143680.aspx

download
http://msdn.microsoft.com/vstudio/express/sql/

khá nhẹ có 56 MB nhưng bạn phải có
# Microsoft .NET Framework 2.0
# SQL Server Setup requires Microsoft Data Access Components (MDAC) 2.8 SP1 or later. You can download MDAC 2.8 SP1 from this Microsoft Web site.

hehe

co 2 bản
Microsoft SQL Server 2005 Express Edition
Microsoft SQL Server 2005 Express Edition is the free, easy-to-use, lightweight version of SQL Server 2005. Integrated with Microsoft Visual Studio 2005, SQL Server Express makes it easy to develop data-driven applications that are rich in capability, offer enhanced storage security, and are fast to deploy. SQL Server Express is free to redistribute and can be seamlessly upgraded to more sophisticated versions of SQL Server.
và
SQL Server 2005 Express Edition with Advanced Services SP2
Microsoft SQL Server 2005 Express Edition with Advanced Services

In addition to the features of SQL Server Express, certain additional capabilities are also available as part of Microsoft SQL Server 2005 Express Edition with Advanced Services (SQL Server Express). SQL Server Express with Advanced Services contains the following features:

SQL Server Management Studio Express, a graphical management tool based on SQL Server Management Studio that makes it easy to manage and administer SQL Server Express databases.

Reporting Services, an integrated report creation and design environment to create reports.

Full-Text Search, a powerful search engine for searching text-intensive data.

SQL Server 2005 Express Edition with Advanced Services SP2 (234 MB)
http://download.microsoft.com/download/1/5/8/15840bb5-30d9-4ba2-b6bd-32424d22f0f9/SQLEXPR_ADV.EXE