468,537 Members | 2,284 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,537 developers. It's quick & easy.

SQL Server 2000 vs SQL Server Express

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 ?

Jul 8 '07 #1
6 2935
Hello Grey,

see there http://www.microsoft.com/sql/edition...s/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

GAI have an ASP.Net website that was developed using SQL Server 2000.
GAI want to 'port' it to use SQL Server Express, since I don't have
GASQL Server 2000 (besides my db is less than 1GB).
GA>
GAQuestions:
GA>
GA1). What is the difference between SQL Server 2000 and SQL Server
GAExpress?
GA>
GA2). What changes (if any) do I have to make to make the website work
GAwith SQL Server express ?
GA>
Jul 8 '07 #2
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/prodinf...-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

MNHello Grey,
MN>
MNsee there http://www.microsoft.com/sql/edition...s/upgrade.mspx
MN>
MN---
MNWBR, Michael Nemtsev [C# MVP].
MNMy blog: http://spaces.live.com/laflour
MNTeam blog: http://devkids.blogspot.com/
MN"The greatest danger for most of us is not that our aim is too high
MNand we miss it, but that it is too low and we reach it" (c)
MNMichelangelo
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>>
Jul 8 '07 #3
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

MNHello Michael ,
MN>
MNUpps, missed that u are asked about full 2k server.
MNWell, you need to compare the features that u use in SQL Server 2000
MNwith
MNthe features supported in 2005
MNhttp://www.microsoft.com/sql/prodinf...-features.mspx
MNto understand which SQL 2005 edition appropriate for you.
MN---
MNWBR, Michael Nemtsev [C# MVP].
MNMy blog: http://spaces.live.com/laflour
MNTeam blog: http://devkids.blogspot.com/
MN"The greatest danger for most of us is not that our aim is too high
MNand we miss it, but that it is too low and we reach it" (c)
MNMichelangelo
MN>
MN>Hello Grey,
MN>>
MN>see there
MN>http://www.microsoft.com/sql/edition...s/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>>>
Jul 8 '07 #4
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...1&cNode=5Y4P1X

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

For specific changes, basically there's two:

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

For a sample <providersentry, see :
http://msdn2.microsoft.com/en-us/lib...pprovider.aspx

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

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

Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en espańol : http://asp.net.do/foros/
======================================
"Grey Alien" <gr**@andromeda.comwrote in message news:k4******************************@bt.com...
>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 ?

Jul 8 '07 #5
Grey Alien wrote:
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.

--

Riki
Jul 8 '07 #6


Grey Alien wrote:
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 ..
Jul 9 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by RDV | last post: by
3 posts views Thread by dale zhang | last post: by
10 posts views Thread by amjad | last post: by
14 posts views Thread by Developer | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.