Re: SQL Server Express as an embedded database
- From: "Dean Mitchell" <not@xxxxxxxxxxxx>
- Date: Wed, 14 Dec 2005 08:54:00 +1300
Thanks for that Roger, it all looks fairly straight forward, not as scary as
I imagining.
Dean
"Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uf9RoS6$FHA.2652@xxxxxxxxxxxxxxxxxxxxxxx
> 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
> >
> >
>
>
.
- References:
- SQL Server Express as an embedded database
- From: Dean Mitchell
- Re: SQL Server Express as an embedded database
- From: Roger Wolter[MSFT]
- SQL Server Express as an embedded database
- Prev by Date: MSDE Purge/shrink not allowed as it would take over 2048MB?
- Next by Date: Creating a user in SQLExpress with SQL Server Management Studio Express
- Previous by thread: Re: SQL Server Express as an embedded database
- Next by thread: SQL Server 2005 Express on 2005
- Index(es):
Relevant Pages
|
