SQL Server 2000 vs SQL Server Express

[Grey Alien]

I have an ASP.Net website that was developed using SQL Server 2000. I
want to 'port' it to use SQL Server Express, since I don't have SQL
Server 2000 (besides my db is less than 1GB).

Questions:

1). What is the difference between SQL Server 2000 and SQL Server Express?

2). What changes (if any) do I have to make to make the website work
with SQL Server express ?

 

[Michael Nemtsev]

Hello Grey,

see there http://www.microsoft.com/sql/editions/express/upgrade.mspx

---
WBR, Michael Nemtsev [C# MVP].
My blog: http://spaces.live.com/laflour
Team blog: http://devkids.blogspot.com/

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo

GA> I have an ASP.Net website that was developed using SQL Server 2000.
GA> I want to 'port' it to use SQL Server Express, since I don't have
GA> SQL Server 2000 (besides my db is less than 1GB).
GA>
GA> Questions:
GA>
GA> 1). What is the difference between SQL Server 2000 and SQL Server
GA> Express?
GA>
GA> 2). What changes (if any) do I have to make to make the website work
GA> with SQL Server express ?
GA>

 

[Michael Nemtsev]

Hello Michael ,

Upps, missed that u are asked about full 2k server.
Well, you need to compare the features that u use in SQL Server 2000 with
the features supported in 2005 http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
to understand which SQL 2005 edition appropriate for you.

---
WBR, Michael Nemtsev [C# MVP].
My blog: http://spaces.live.com/laflour
Team blog: http://devkids.blogspot.com/

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo

MN> Hello Grey,
MN>
MN> see there http://www.microsoft.com/sql/editions/express/upgrade.mspx
MN>
MN> ---
MN> WBR, Michael Nemtsev [C# MVP].
MN> My blog: http://spaces.live.com/laflour
MN> Team blog: http://devkids.blogspot.com/
MN> "The greatest danger for most of us is not that our aim is too high
MN> and we miss it, but that it is too low and we reach it" (c)
MN> Michelangelo
MN>
GA>> I have an ASP.Net website that was developed using SQL Server 2000.
GA>> I want to 'port' it to use SQL Server Express, since I don't have
GA>> SQL Server 2000 (besides my db is less than 1GB).
GA>>
GA>> Questions:
GA>>
GA>> 1). What is the difference between SQL Server 2000 and SQL Server
GA>> Express?
GA>>
GA>> 2). What changes (if any) do I have to make to make the website
GA>> work with SQL Server express ?
GA>>

 

[Michael Nemtsev]

Hello Michael ,

Btw, there http://www.dbazine.com/sql/sql-articles/cook19 are some recomendations
about SQL 2k upgrage to 2k5

---
WBR, Michael Nemtsev [C# MVP].
My blog: http://spaces.live.com/laflour
Team blog: http://devkids.blogspot.com/

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo

MN> Hello Michael ,
MN>
MN> Upps, missed that u are asked about full 2k server.
MN> Well, you need to compare the features that u use in SQL Server 2000
MN> with
MN> the features supported in 2005
MN> http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
MN> to understand which SQL 2005 edition appropriate for you.
MN> ---
MN> WBR, Michael Nemtsev [C# MVP].
MN> My blog: http://spaces.live.com/laflour
MN> Team blog: http://devkids.blogspot.com/
MN> "The greatest danger for most of us is not that our aim is too high
MN> and we miss it, but that it is too low and we reach it" (c)
MN> Michelangelo
MN>
MN>> Hello Grey,
MN>>
MN>> see there
MN>> http://www.microsoft.com/sql/editions/express/upgrade.mspx
MN>>
MN>> ---
MN>> WBR, Michael Nemtsev [C# MVP].
MN>> My blog: http://spaces.live.com/laflour
MN>> Team blog: http://devkids.blogspot.com/
MN>> "The greatest danger for most of us is not that our aim is too high
MN>> and we miss it, but that it is too low and we reach it" (c)
MN>> Michelangelo
GA>>> I have an ASP.Net website that was developed using SQL Server
GA>>> 2000. I want to 'port' it to use SQL Server Express, since I don't
GA>>> have SQL Server 2000 (besides my db is less than 1GB).
GA>>>
GA>>> Questions:
GA>>>
GA>>> 1). What is the difference between SQL Server 2000 and SQL Server
GA>>> Express?
GA>>>
GA>>> 2). What changes (if any) do I have to make to make the website
GA>>> work with SQL Server express ?
GA>>>

 

[Juan T. Llibre]

Hi, Grey.

Over and above what Michael has already pointed out,
you will want to take a look at these two articles :

SQL Server 2005 vs. SQL Server 2005 Express vs. MSDE:
http://help.alentus.com/article.aspx?id=10471&cNode=5Y4P1X

SQL Server 2005 Features Comparison:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

For specific changes, basically there's two:

You need to have a <providers> entry, if you want to use Membership services,
and/or a "connectionStrings" entry in web.config for regular SQL Express databases.

For a sample <providers> entry, see :
http://msdn2.microsoft.com/en-us/library/system.web.security.sqlmembershipprovider.aspx

See this Scott Guthrie blog entry, which shows you sample entries for <connectionStrings>:
http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

"Using SQL Server Express Edition with ASP.NET" has useful info, too.
http://msdn2.microsoft.com/en-us/library/ms228037(VS.80).aspx

 

[Riki]

I have an ASP.Net website that was developed using SQL Server 2000. I
want to 'port' it to use SQL Server Express, since I don't have SQL
Server 2000 (besides my db is less than 1GB).

Questions:

1). What is the difference between SQL Server 2000 and SQL Server
Express?

See the other responses. If you don't use replication or backup, you won't
have many problems, I guess.

2). What changes (if any) do I have to make to make the website work
with SQL Server express ?

Just change the connection string.

 

[Grey Alien]

I have an ASP.Net website that was developed using SQL Server 2000. I
want to 'port' it to use SQL Server Express, since I don't have SQL
Server 2000 (besides my db is less than 1GB).

Questions:

1). What is the difference between SQL Server 2000 and SQL Server Express?

2). What changes (if any) do I have to make to make the website work
with SQL Server express ?

Thanks guys ..