Which one better SQL Server 2000 or 2005 for ASP NEt

  • Thread starter Thread starter haries.ahmad
  • Start date Start date
H

haries.ahmad

Hi all..

i'm newbie in aspnet. i kind a confuse which one should i use for my
database system. SQL 2000 or 2005, and what is the different.

thankyou
 
Usually, the newer version of SQL Server the better. Mostly it's features
available. SQL Server 2005 has a lot of things different about it.
Unfortunatley, most won't mean much to you if you haven't developed for SQL
Server for a while. SQL Server 2005 is nice because there is a free express
version that you can download and use to get your feet wet with developing
for SQL server. One of the nice features is the inclusion of a native XML
datatype within SQL Server, as well as integration with the .Net CLR. Like I
said though, a lot of these things won't mean much if you haven't been
developing with them for a while. One of the important factors though, is
determining which version your chosen web host has. If your host/company
only has SQL Server 2000 and isn't planning to upgrade anytime soon, you may
as well start with SQL Server 2000 since it's always easier to upgrade to a
newer version then it is to check if you've used features from a newer
version to go backwards from SQL 2005 to SQL 2000.
 
Back
Top