deployment question

I am wondering about some capacity that, I have heard, might be installed in
SqlServer 2005.
I am writting an end user application that I want to have low hardware
requirement (apart from running .NET).
I would like to use a SqlServer database for data repository, but I don't
want a server, it would be a file based data stored, only for the
application and would (absolutely) not require a previous server software to
be installed.
Something like I could do with SqlLite, except SqlServer have plenty of nice
graphical tools.
Is it possible to do something like that with SqlServer? how?
What are the licensing consideration?SQL Server 2000 MSDE:
http://www.microsoft.com/sql/MSDE/
MSDE is replaced by Express Edition in SQL Server 2005:
http://lab.msdn.microsoft.com/express/sql/
David Portas
SQL Server MVP
--|||YOu can use SQL Server 2005 Express Edition:
"First, SQL Server 2000 Desktop Edition is being retired. In its place, we
get SQL Server 2005 Express Edition. Express Edition will still be free,
embeddable, and redistributable. But unlike Desktop Edition, it will include
a graphical management tool, as well as some other goodies like a report
wizard and controls, plus support for new technologies including SQL Service
Broker and the Common Language Runtime. All in all, Express Edition should
significantly raise the bar for the use of SQL Server is low-cost
applications (and may be the death knell for the venerable Jet engine)."
(quoted from: http://www.developer.com/db/article.php/3502746)
Information anout that can be found here:
http://www.microsoft.com/sql/express/
CTP can be downloaded here:
http://www.microsoft.com/downloads/...&displaylang=en
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Lloyd Dupont" <ld@.NewsAccount.galador.net> schrieb im Newsbeitrag
news:OK9dkRhWFHA.3760@.TK2MSFTNGP15.phx.gbl...
>I am wondering about some capacity that, I have heard, might be installed
>in SqlServer 2005.
> I am writting an end user application that I want to have low hardware
> requirement (apart from running .NET).
> I would like to use a SqlServer database for data repository, but I don't
> want a server, it would be a file based data stored, only for the
> application and would (absolutely) not require a previous server software
> to be installed.
> Something like I could do with SqlLite, except SqlServer have plenty of
> nice graphical tools.
> Is it possible to do something like that with SqlServer? how?
> What are the licensing consideration?
>|||Thanks guys!
looks like Sql5 - express is going to be fine!|||Depending on the complexity of your data storage needs, MS Access or even
XML might suffice. MSDE can comsume CPU and memory.
"Lloyd Dupont" <ld@.NewsAccount.galador.net> wrote in message
news:OK9dkRhWFHA.3760@.TK2MSFTNGP15.phx.gbl...
> I am wondering about some capacity that, I have heard, might be installed
in
> SqlServer 2005.
> I am writting an end user application that I want to have low hardware
> requirement (apart from running .NET).
> I would like to use a SqlServer database for data repository, but I don't
> want a server, it would be a file based data stored, only for the
> application and would (absolutely) not require a previous server software
to
> be installed.
> Something like I could do with SqlLite, except SqlServer have plenty of
nice
> graphical tools.
> Is it possible to do something like that with SqlServer? how?
> What are the licensing consideration?
>|||hu...
I want something which don't requires additional install or program from the
user.
for instance, what if he hasn't bought access? (very likely case...)
"JT" <someone@.microsoft.com> wrote in message
news:O3FZxOiWFHA.1148@.tk2msftngp13.phx.gbl...
> Depending on the complexity of your data storage needs, MS Access or even
> XML might suffice. MSDE can comsume CPU and memory.
> "Lloyd Dupont" <ld@.NewsAccount.galador.net> wrote in message
> news:OK9dkRhWFHA.3760@.TK2MSFTNGP15.phx.gbl...
> in
> to
> nice
>|||You only need ADO to query an Access .MDB database or XML file, and ADO
comes pre-installed with Windows. However, the user will need to install
MSDE. That's why I suggested an Access database or XML over MSDE.
"Lloyd Dupont" <net.galador@.ld> wrote in message
news:OSOQIbmWFHA.1384@.TK2MSFTNGP09.phx.gbl...
> hu...
> I want something which don't requires additional install or program from
the
> user.
> for instance, what if he hasn't bought access? (very likely case...)
> "JT" <someone@.microsoft.com> wrote in message
> news:O3FZxOiWFHA.1148@.tk2msftngp13.phx.gbl...
even
installed
don't
software
>|||ho.. sounds much better then, thanks!
"JT" <someone@.microsoft.com> wrote in message
news:OKHp5PuWFHA.2740@.TK2MSFTNGP14.phx.gbl...
> You only need ADO to query an Access .MDB database or XML file, and ADO
> comes pre-installed with Windows. However, the user will need to install
> MSDE. That's why I suggested an Access database or XML over MSDE.
>
> "Lloyd Dupont" <net.galador@.ld> wrote in message
> news:OSOQIbmWFHA.1384@.TK2MSFTNGP09.phx.gbl...
> the
> even
> installed
> don't
> software
>|||MSDE / SQL Server Express Edition is feature rich and would use the same
database format as SQL Server, but the install and maintenance requirements
may exceed what you are willing to deploy in the field. Inquire in the
*msde* newsgroup about others experiences with this.
"Lloyd Dupont" <ld@.NewsAccount.galador.net> wrote in message
news:%23540LXuWFHA.2976@.TK2MSFTNGP10.phx.gbl...
> ho.. sounds much better then, thanks!
> "JT" <someone@.microsoft.com> wrote in message
> news:OKHp5PuWFHA.2740@.TK2MSFTNGP14.phx.gbl...
from
hardware
>