SQL Server Vs MSDE or other?

[joe]

I'm using VS.Net and develop for both websites (ASP.NET) and windows desktop
applications. Most of my ASP.Net work is data driven and I am using SQL
SERVER for scalability. I am however running into a bit of a bind when
developing for smaller website owners and small scale windows applications
where scalability and (CO$TO) is an issue. Often they can't justify the
additional expense of SQL Server to run their apps.

I considered adding SQLSRVRDesktop to my machine which already has had
SQLServer2000 installed but there appear to be some issues with that as far
as I can see from reading others comments.

What are some of the ways you guys/gals are using to deal with this issue
(if at all)?

 

[grrrr]

MSDE IS almost identical to MSSQL except for the lack of client tools
(profiler, enterprise service manager etc), but all normal functions can be
administered through SQL statements (create, drop for users, objects etc)

you can continue to develop on MSSQL and, provided you build the necessary
admin tools you require into your app, you can redistribute with MSDE

 

[joe]

you can continue to develop on MSSQL and, provided you build the necessary

admin tools you require into your app, you can redistribute with MSDE

Good idea! How simple.....I could kick myself for not thinking of that!
Duh

 

[joe]

I'll take a look...thanks.

suprizingly enough, planet-source-code.com has a submission that is very
close to sql server enterprize manager. suprising b/c everything else there
is crap. look under the vb category, search for "msde", download the source
(the one i use is called dbmanager...i think...look for the 5 globe
submission) and compile at will.

hth,

steve

 

[joe]

Steve,
So it looks like in my situation this product (dbmanager) would be used at
the client site to assist in setting up an msde database since I already
have MS SQL Sever 2000 Ent on my development machine. Is that right?

 

[steve]

exactly...btw, the real name was dbaMGR2K if that helps. it's a ui wrapped
around sqldmo.

hth

 

[joe]

got it...thanks again

exactly...btw, the real name was dbaMGR2K if that helps. it's a ui wrapped
around sqldmo.

hth