Re: DB or no DB?

SQL Express (and before it SQL Server 2000 Personal Edition - see
http://www.microsoft.com/sql/techinfo/planning/ChoosEd.doc) are totally
designed to run on the client. That's their target audience. See
http://www.microsoft.com/sql/editions/express/default.mspx '...Easily Embed
a Local Database for Your Application...'

The 'server' in their title is indeed a little confusing but that's just the
way it is. They even have a Sql Server Mobile
http://www.microsoft.com/sql/editions/sqlmobile/default.mspx for phones and
PDAs so obviously the 'server' in the name does not mean you can only run on
a server.

As for using it, I disagree. If you have an application that needs to store
and query structured data then a DBMS is a perfectly valid way of doing it.
Depending on your requirements for storage and query it may be overkill but
that's the developers decision to make. If you are a SQL expert then maybe
using something you already know is a big productivity advantage rather than
changing the way you think - and remember there are a *lot* of .Net
developers that know SQL very well. There is nothing that says databases are
only for B2B applications. That is of course, just my opinion.

--
Zman
http://www.thezbuffer.com - News and information for Managed DirectX



"vidalsasoon" <kjobson@xxxxxxxxx> wrote in message
news:1139845093.651946.318680@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Well it's called SQL "Server" Express... I never worked with the
express version but I do know that the full version is indeed a
server...
Anyway, It's a bad idea unless maybe you're making a B2B application.



.

Relevant Pages

  • RE: [PHP] security include from remote server
    ... files someplace else, but still access the local database? ... You would also need to allow the connection from the remote host in mysql. ... database server. ...
    (php.general)
  • Re: mobile SQL embedded on WinCE
    ... SQL CE Server is in the catalog in Platform Builder, ... I have hope that mobile SQL could be incorporated in platform ... doing a local database on the device and synching our database to a ... server on the internet. ...
    (microsoft.public.windowsce.embedded)
  • Re: SQL Database Connection
    ... Yes it makes your app more scalable to have business rules on a server - ... Whereas the Web Service does. ... I would suggest that you have a local database on the device so when ... Agent included in the Mobile Client Software Factory by the Microsoft ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Database/WebAccess
    ... Regarding your synchronisation question of the local database with the ... remote internet database question. ... With SQL server you can define a Linked Server and write the necesssary ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: Realbasic 2008 and MS SQL
    ... Valentina DB - BOTH for local database solutions and for server ... Your local app can generate reports from local databases, ...
    (comp.lang.basic.realbasic)