473,241 Members | 1,513 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 software developers and data experts.

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 3065
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

48
by: ik | last post by:
ERROR after uninstalling SQL Server 2005 Express I get this message, SQLDMO has not been registered. Please re-run your setupand contact your system administrator. GREAT!!! ReInstalled SQL...
5
by: RDV | last post by:
I have 2 SQL Server Express questions: 1) Can you manage a SQL Server Express installation from the regular SQL Server Enterprise Manager? I am getting a message that says "SQL Server does not...
3
by: dale zhang | last post by:
Hi, I write an asp.net web application. It has a “Contact Us” page, where users fill in their email, subject and text and hit send. Then the email will go to my hard coded yahoo email...
10
by: amjad | last post by:
how to connection sql server table with aspx like pulling data from table to grid view.... simple example to start .... thanks
5
by: Jack | last post by:
Hello, I had SQL2000 server running fine on the windows 2003 box. I then installed SQL 2005 Express. They both worked together fine. I then uninstalled SQL 2005 Express and installed SQL 2005...
14
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can...
12
by: Light | last post by:
Hi all, I posted this question in the sqlserver.newusers group but I am not getting any response there so I am going to try it on the fine folks here:). I inherited some legacy ASP codes in my...
3
by: Steve | last post by:
Hi All I downloaded Sql server 2005 express SP2 and attempted to modify the Bootstrapper package files as I did with SP1 When i try to install SQL server as part of my VS 2005 deployment app I...
10
by: Scott M. | last post by:
I've seen many posts and ready articles discussing how changing the membership & roles "provider" in VS .NET is easy, but have yet to see instructions on how to do it. If I already have SQL...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.