Re: SQL Server Express as an embedded database
- From: "Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 12 Dec 2005 21:18:09 -0800
The Express install can be embedded in your product's installation program.
Here's a whitepaper that should help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/EmSQLExCustApp.asp
Many applications upgrade their database as part of service packs of
software upgrade. The most common way to do this is to create a SQL script
that includes the required ALTER statements to upgrade the database and have
the setup run the script with sqlcmd.exe.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Dean Mitchell" <not@xxxxxxxxxxxx> wrote in message
news:ODYTOU2$FHA.740@xxxxxxxxxxxxxxxxxxxxxxx
> Hi everyone,
>
> We have a requirement to distribute a database with our client-server
> application. From a database perspective the application is not
> particularly complex. We have a couple of servers that need to connect to
> the database using ODBC (none of the clients will connect to the
> database),
> and the servers are mainly single threaded, although there is the odd
> occassion where they will create another thread do some work, but 99% of
> the
> time they are single threaded.
>
> So SQL Server Express seems like it will do the job for us, my boss
> particularly likes the cost!. But I would like to effectively embed the
> database within the application, so the installer is not necessarily aware
> that there is a database involved, as alot of the time the people doing
> the
> installation will be 3rd party dealers who are not necessarily that
> knowlegable about such things.
>
> Our application installs very straight forward at the moment, they just
> run
> the installer and answer a few question, the rest is all self configuring.
> So I would like it to stay simple, is this possible when incorportaing a
> database, and how would we go about such tasks as creating a database
> instance, adding/modifying the tables, and configuring an ODBC connection?
>
> The other issue is how do we cope with upgrades, we have frequent upgrades
> to the software, 1-2 a month and not all of them would involve changes to
> the tables. And as we do not upgrade all the customers each time, when
> they
> do get upgraded they may be jumping several version at a time. it would
> need
> to be able to cope with upgrades seamlessly. How do we upgrade our
> database
> by adding tables, or columsn to existing tables? Ultimately I would like
> the whole process to be automated.
>
> Am I being overambitious with what I would like to do?
>
> Unfortunately we are stuck with an application written in Borlands
> CppBuilder, so we have access to any of the tools that I suspect are
> provided with Visual Studio. We use Wise for Windows Installers which has
> a
> capability of installing SQL Server databases, but they appear to drop the
> tables if there is any modification required. As that would result in
> loss
> of data, that is not a acceptable solution.
>
> thanks for everyones time
> Regards
> Dean
>
>
.
- Follow-Ups:
- Re: SQL Server Express as an embedded database
- From: Dean Mitchell
- Re: SQL Server Express as an embedded database
- References:
- SQL Server Express as an embedded database
- From: Dean Mitchell
- SQL Server Express as an embedded database
- Prev by Date: Re: MSDE and Linux server
- Next by Date: SQL Server 2005 Express on 2005
- Previous by thread: SQL Server Express as an embedded database
- Next by thread: Re: SQL Server Express as an embedded database
- Index(es):
Relevant Pages
|
