473,320 Members | 1,722 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,320 software developers and data experts.

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)?

Nov 19 '05 #1
6 1692
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" <contact_by_Newsgroup_only.please> wrote in message
news:Oz**************@tk2msftngp13.phx.gbl...
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)?

Nov 19 '05 #2
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

Nov 19 '05 #3
joe
I'll take a look...thanks.
"steve" <as*@abc.com> wrote in message
news:vg************@corp.supernews.com...
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" <contact_by_Newsgroup_only.please> wrote in message
news:eI**************@TK2MSFTNGP11.phx.gbl...
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


Nov 19 '05 #4
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?

"joe" <contact_by_Newsgroup_only.please> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
I'll take a look...thanks.
"steve" <as*@abc.com> wrote in message
news:vg************@corp.supernews.com...
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" <contact_by_Newsgroup_only.please> wrote in message
news:eI**************@TK2MSFTNGP11.phx.gbl...
> 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



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

hth

"joe" <contact_by_Newsgroup_only.please> wrote in message
news:%2******************@tk2msftngp13.phx.gbl...
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?

"joe" <contact_by_Newsgroup_only.please> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
I'll take a look...thanks.
"steve" <as*@abc.com> wrote in message
news:vg************@corp.supernews.com...
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" <contact_by_Newsgroup_only.please> wrote in message
news:eI**************@TK2MSFTNGP11.phx.gbl...
> > 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
>
>
>



Nov 19 '05 #6
joe
got it...thanks again
"steve" <as*@abc.com> wrote in message
news:vg************@corp.supernews.com...
exactly...btw, the real name was dbaMGR2K if that helps. it's a ui wrapped
around sqldmo.

hth

"joe" <contact_by_Newsgroup_only.please> wrote in message
news:%2******************@tk2msftngp13.phx.gbl...
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?

"joe" <contact_by_Newsgroup_only.please> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...
I'll take a look...thanks.
"steve" <as*@abc.com> wrote in message
news:vg************@corp.supernews.com...
> 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" <contact_by_Newsgroup_only.please> wrote in message
> news:eI**************@TK2MSFTNGP11.phx.gbl...
> > > 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
> >
> >
> >
>
>



Nov 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Ray Lavelle | last post by:
I have an application which runs in many different stores. Stores that are within a chain want to be able to share their client lists. I want to implement a sync process where each application...
5
by: Robin Tucker | last post by:
I'm looking for a simple way of telling (inside a stored procedure) if I'm currently using MSDE or a full SQL server. Ideally, there is some pre-defined environment variable that won't cause me...
1
by: gcetti | last post by:
Can an individual computer be configured contain both a SQL Server instance & an MSDE instance? Our software we charge separate costs depending if they are running on a MSDE or SQL Server...
6
by: Colin McNaught | last post by:
Hi, I find myself having to support a small ASP/VB/Access web application for a customer of mine. (Our main expertise is PHP/MySQL/Apache). Other than testing on the Customers ISP's Server, are...
3
by: NWx | last post by:
Hi, I write an ASP,NET application who uses SQL Server (MSDE) as Back-end I'm an experienced developer, but haven't used SQL server before and I need some help. Since I don't have full SQL...
9
by: Piedro | last post by:
Hi Group, I haven written a program on a win 2000 pc and sql server 2000, in the sql server there're about 40 tables with data and now I'm deploying my project on a test pc with windows xp...
5
by: Microsoft | last post by:
Hi, I have Visual Basic .net 2003 (Standard Edition) & SQL Server 2000 Developer Edition. When trying to create a connection in the server explorer from the .net IDE I get a number of problems;...
5
by: B1ackwater | last post by:
We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a...
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...
2
by: isa | last post by:
Hello everyone, i want to transfer/copy data from MSDE to SQL Server 2000 and from SQL Server to MSDE, through Stored Procedures , not using a "Replication", kindly tell me how i make a SP for...
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...
1
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.