MSDE to SQL Server 2005 Express

Howdy,
My company is setting up a new dedicated hosting server and we're debating
using the new SQL 2005 verse the MSDE. I'm not familiar with the new
version, so I have one big question:: Outside of the connection string, will
any syntax in my existing ASP.NET script/stored procs have to change to
support SQL 2005? Is the migration process painless?
I've searched MSDN but really can't find what I'm looking for.
Thanks,
David Lozzi
Web Applications Developer
dlozzi@.(remove-this)delphi-ts.comHello David,

> Outside of the
> connection string, will any syntax in my existing ASP.NET
> script/stored procs have to change to support SQL 2005?
Without specifics, its hard to say precisely. Some things change some, a
few a lot, most hardly at all. There's an upgrade advisor tool on the distri
bution
media and here [0] that I'd recommend starting with. It should catch a major
ity
of the changes needed with a minimum of effort.

> Is the
> migration process painless?
Again, that depends on what you've done in the past. I suspect not, but the
upgrade advisor will help you know more for sure.
[0]: http://www.microsoft.com/downloads/...&displaylang=en
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

MSDE on a Dedicated Webserver

Hi, our company is running a couple of java based applications on a dedicated webserver. We are interested in running the Rainbow Portal on this server as well (as a public website), but the actual owner of the server doesn't want to outlay the cash for S
QL Server at the moment. Would it be legal for us to install MSDE on this webserver to use as the database engine for the Rainbow Portal? (bearing in mind that it's a dedicated webserver, and that there would only be one instance of MSDE, and probably onl
y one database)
Sounds like it would be ok, but check the information at this link.
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Jim
"Nicholas Smeaton" <nsmeaton@.footbag.org> wrote in message
news:89AA18C5-9A3B-47CE-914B-9DC0263196BD@.microsoft.com...
> Hi, our company is running a couple of java based applications on a
dedicated webserver. We are interested in running the Rainbow Portal on this
server as well (as a public website), but the actual owner of the server
doesn't want to outlay the cash for SQL Server at the moment. Would it be
legal for us to install MSDE on this webserver to use as the database engine
for the Rainbow Portal? (bearing in mind that it's a dedicated webserver,
and that there would only be one instance of MSDE, and probably only one
database)
|||Thanks Jim, but I'm still a bit hazy on the details. The "Appropriate Uses of MSDE FAQ" page says it's appropriate to use it as a database for a website, but the EULA says: "NO RENTAL/COMMERCIAL HOSTING". Seems a bit contradictory, and I need to be absolu
tely sure. I guess it'll be the owner of the dedicated webserver that'll be offering it to our company, but they won't be charging us to use it, and we'll be the only one's using it. It *sounds* like it should be ok, but can someone give me a definitive y
ea or nay?
|||IMHO u cant legally use MSDE in this situation
"Nicholas Smeaton" <nsmeaton@.footbag.org> wrote in message
news:89AA18C5-9A3B-47CE-914B-9DC0263196BD@.microsoft.com...
> Hi, our company is running a couple of java based applications on a
dedicated webserver. We are interested in running the Rainbow Portal on this
server as well (as a public website), but the actual owner of the server
doesn't want to outlay the cash for SQL Server at the moment. Would it be
legal for us to install MSDE on this webserver to use as the database engine
for the Rainbow Portal? (bearing in mind that it's a dedicated webserver,
and that there would only be one instance of MSDE, and probably only one
database)
|||John,
MS changed licensing for MSDE a while ago. Nowadays, it is "free". As far as I can read below URL, using MSDE
in the scenario described would be OK...
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"John Smith" <a__@.abv.bg> wrote in message news:uEW7yg0NEHA.3672@.TK2MSFTNGP11.phx.gbl...
> IMHO u cant legally use MSDE in this situation
>
> "Nicholas Smeaton" <nsmeaton@.footbag.org> wrote in message
> news:89AA18C5-9A3B-47CE-914B-9DC0263196BD@.microsoft.com...
> dedicated webserver. We are interested in running the Rainbow Portal on this
> server as well (as a public website), but the actual owner of the server
> doesn't want to outlay the cash for SQL Server at the moment. Would it be
> legal for us to install MSDE on this webserver to use as the database engine
> for the Rainbow Portal? (bearing in mind that it's a dedicated webserver,
> and that there would only be one instance of MSDE, and probably only one
> database)
>
|||but what about this: "
Q. How do I acquire rights to deploy MSDE throughout my company?
A. The following products allow you to deploy MSDE throughout your
organization:
a.. MSDN Universal, Enterprise, and Professional subscriptions
b.. SQL Server 2000 Developer, Standard, and Enterprise Editions
c.. Visual Studio .NET Architect, Developer, and Professional
Editions
d.. Visual FoxPro 7.0 or 8.0
Note: Microsoft Access only provides rights to use MSDE on the device
on which Microsoft Access is installed.
"
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:Oxouso0NEHA.3264@.tk2msftngp13.phx.gbl...
> John,
> MS changed licensing for MSDE a while ago. Nowadays, it is "free". As far
as I can read below URL, using MSDE
> in the scenario described would be OK...
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "John Smith" <a__@.abv.bg> wrote in message
news:uEW7yg0NEHA.3672@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
this[vbcol=seagreen]
be[vbcol=seagreen]
engine[vbcol=seagreen]
webserver,
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
|||Yes, I asked MS to clarify that point, something they apparently didn't do. My assumption is that it is either
a leftover or it refers to re-distributing within your own organization...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"John Smith" <a__@.abv.bg> wrote in message news:eYfrXi%23NEHA.3348@.TK2MSFTNGP09.phx.gbl...
> but what about this: "
> Q. How do I acquire rights to deploy MSDE throughout my company?
> A. The following products allow you to deploy MSDE throughout your
> organization:
> a.. MSDN Universal, Enterprise, and Professional subscriptions
> b.. SQL Server 2000 Developer, Standard, and Enterprise Editions
> c.. Visual Studio .NET Architect, Developer, and Professional
> Editions
> d.. Visual FoxPro 7.0 or 8.0
> Note: Microsoft Access only provides rights to use MSDE on the device
> on which Microsoft Access is installed.
> "
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:Oxouso0NEHA.3264@.tk2msftngp13.phx.gbl...
> as I can read below URL, using MSDE
> news:uEW7yg0NEHA.3672@.TK2MSFTNGP11.phx.gbl...
> this
> be
> engine
> webserver,
>
>
|||if u get an answer post it here plz
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OB2Hqx%23NEHA.3012@.tk2msftngp13.phx.gbl...
> Yes, I asked MS to clarify that point, something they apparently didn't
do. My assumption is that it is either
> a leftover or it refers to re-distributing within your own organization...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
|||I asked again last week, but I didn't get a reply yet. Probably an MS representative or below is the best bet:
"To speak to someone regarding licensing:
You can call 1-800-426-9400 (select option 4), Monday through Friday, 6:00
A.M. to 6:00 P.M. (PST) to speak directly to a Microsoft licensing
specialist for licensing problem. Worldwide customers can use the Guide to
Worldwide Microsoft Licensing Sites
http://www.microsoft.com/licensing/index/worldwide.asp to find contact
information in their locations."
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Smith" <a__@.abv.bg> wrote in message news:%23aOzQ0%23NEHA.4036@.TK2MSFTNGP12.phx.gbl...
> if u get an answer post it here plz
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OB2Hqx%23NEHA.3012@.tk2msftngp13.phx.gbl...
> do. My assumption is that it is either
>

msde licence

we get from a company installed at our customer sides an application using
msde in a win 2000 server (terminal) or higher network enwironment. We have a
lot of troubles because this application is going to let our application fail
often , and we get a lot of instability.
Hi rudolph,
Sorry, but dont' see a question here. Why do you think that the MSDE is
causing instability for your app?
Regards,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"rudolph" <rudolph@.discussions.microsoft.com> wrote in message
news:121817FD-B051-4D59-9690-BDD6DA952ADA@.microsoft.com...
> we get from a company installed at our customer sides an application using
> msde in a win 2000 server (terminal) or higher network enwironment. We
> have a
> lot of troubles because this application is going to let our application
> fail
> often , and we get a lot of instability.
|||Hi Greg!
My question is, that we have done out of a pervasive sql based application
an Interface to a small application. This small application is using msde in
a enviroment, we are using, win 2003 or winn200 Server with terminal clients.
The company, who has done the small aplication we are interfacing has
installed at our clients side either msde or MSSQL Server products, depending
on their stability.We have not been asked by them what they are going to
install I thought, that msde is a client product and not a server product. IS
msde a product which can run simitaniosly in our environment?
"Greg Low [MVP]" wrote:

> Hi rudolph,
> Sorry, but dont' see a question here. Why do you think that the MSDE is
> causing instability for your app?
> Regards,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "rudolph" <rudolph@.discussions.microsoft.com> wrote in message
> news:121817FD-B051-4D59-9690-BDD6DA952ADA@.microsoft.com...
>
>
|||hi Rudolph,
rudolph wrote:
> Hi Greg!
> My question is, that we have done out of a pervasive sql based
> application an Interface to a small application. This small
> application is using msde in a enviroment, we are using, win 2003 or
> winn200 Server with terminal clients. The company, who has done the
> small aplication we are interfacing has installed at our clients side
> either msde or MSSQL Server products, depending on their stability. We
> have not been asked by them what they are going to install I thought,
> that msde is a client product and not a server product. IS msde a
> product which can run simitaniosly in our environment?
I'm not Greg (hi Greg :D) but, again, I do not understand the "stability"
problems...
MSDE is one of the editions of SQL Server, limited some way, but shares the
same core functionnalities and features...
MSDE is not a client product as Access, it's a "scaled down" version of a
full blown "enterprise" DBMS, with built-in limitation for database size,
concurrent workloads, and so on...
as regard as your last question,
>IS msde a
> product which can run simitaniosly in our environment?
I should say yes, but your environment is not public , and of course it
all depends on your requirements..
regards
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Rudolph,
And to add to what Andrea said, we've used it in that sort of environment
many, many times without issue.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:35pbuqF4pmdlaU1@.individual.net...
> hi Rudolph,
> rudolph wrote:
> I'm not Greg (hi Greg :D) but, again, I do not understand the "stability"
> problems...
> MSDE is one of the editions of SQL Server, limited some way, but shares
> the
> same core functionnalities and features...
> MSDE is not a client product as Access, it's a "scaled down" version of a
> full blown "enterprise" DBMS, with built-in limitation for database size,
> concurrent workloads, and so on...
> as regard as your last question,
> I should say yes, but your environment is not public , and of course it
> all depends on your requirements..
> regards
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>