Distribution of SQLServer Database

Hi,
We're in the process of developing a .NET application which will use a
SQLServer database. When installed/deployed the application will query this
database. I assume each time the application is installed the SQL Server
database will need to be installed. Is this the case - sorry I know it's a
dumb question but I am a complete SQL Server novice. If this is the case then
which licensing option should we go for?
Any help would be greatly appreciated.
-KimHi Kim
There is a version of SQL Server which is designed to be deployed with user
programs. It's called MSDE & you can read more about it here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_67ax.asp
There are limits on it's growth (2Gb per db, max 2 CPUs etc) & if you exceed
these, you'd probably be looking at SQL Server Standard Edition.
Regards,
Greg Linwood
SQL Server MVP
"kim d" <kimd@.discussions.microsoft.com> wrote in message
news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> Hi,
> We're in the process of developing a .NET application which will use a
> SQLServer database. When installed/deployed the application will query
> this
> database. I assume each time the application is installed the SQL Server
> database will need to be installed. Is this the case - sorry I know it's a
> dumb question but I am a complete SQL Server novice. If this is the case
> then
> which licensing option should we go for?
> Any help would be greatly appreciated.
> -Kim|||It also depends on what you mean about deplying SQL... YOu might wish all of
the clients to share data from a single database, or you might wish to
install the MSDE version on each client, so there is no data sharing...
In either case, at least you will have to the the SQL Connectivity piece on
the client.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"kim d" <kimd@.discussions.microsoft.com> wrote in message
news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> Hi,
> We're in the process of developing a .NET application which will use a
> SQLServer database. When installed/deployed the application will query
this
> database. I assume each time the application is installed the SQL Server
> database will need to be installed. Is this the case - sorry I know it's a
> dumb question but I am a complete SQL Server novice. If this is the case
then
> which licensing option should we go for?
> Any help would be greatly appreciated.
> -Kim|||Ideally clients would share data from a single database but there would be
the capability to work 'off-line' - in other words users could access the
database even while not explicitly connected to the server. I presume in this
case it would require a separate MSDE installation on each client as well as
on the server database. Does MSDE support this type of behaviour?
"Wayne Snyder" wrote:
> It also depends on what you mean about deplying SQL... YOu might wish all of
> the clients to share data from a single database, or you might wish to
> install the MSDE version on each client, so there is no data sharing...
> In either case, at least you will have to the the SQL Connectivity piece on
> the client.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "kim d" <kimd@.discussions.microsoft.com> wrote in message
> news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> > Hi,
> > We're in the process of developing a .NET application which will use a
> > SQLServer database. When installed/deployed the application will query
> this
> > database. I assume each time the application is installed the SQL Server
> > database will need to be installed. Is this the case - sorry I know it's a
> > dumb question but I am a complete SQL Server novice. If this is the case
> then
> > which licensing option should we go for?
> > Any help would be greatly appreciated.
> > -Kim
>
>|||Great, so does this mean that we would only need to purchase a SQLServer
developers license?
"Greg Linwood" wrote:
> Hi Kim
> There is a version of SQL Server which is designed to be deployed with user
> programs. It's called MSDE & you can read more about it here:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_67ax.asp
> There are limits on it's growth (2Gb per db, max 2 CPUs etc) & if you exceed
> these, you'd probably be looking at SQL Server Standard Edition.
> Regards,
> Greg Linwood
> SQL Server MVP
> "kim d" <kimd@.discussions.microsoft.com> wrote in message
> news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> > Hi,
> > We're in the process of developing a .NET application which will use a
> > SQLServer database. When installed/deployed the application will query
> > this
> > database. I assume each time the application is installed the SQL Server
> > database will need to be installed. Is this the case - sorry I know it's a
> > dumb question but I am a complete SQL Server novice. If this is the case
> > then
> > which licensing option should we go for?
> > Any help would be greatly appreciated.
> > -Kim
>
>|||In this case, you'd be looking at Personal Edition, which is on the SS
media. Then you replicate the Central Database to your clients, which can
then go "offline."
That's what this edition was created for. It has restrictions, but
different than those of MSDE, which is more an Access database replacement.
SS Personal Edition is more for business, semi-connected users, like sales
staff.
Sincerely,
Anthony Thomas
"kim d" <kimd@.discussions.microsoft.com> wrote in message
news:7E0720DF-6224-4B91-A92E-5D4C542D7FC3@.microsoft.com...
Ideally clients would share data from a single database but there would be
the capability to work 'off-line' - in other words users could access the
database even while not explicitly connected to the server. I presume in
this
case it would require a separate MSDE installation on each client as well as
on the server database. Does MSDE support this type of behaviour?
"Wayne Snyder" wrote:
> It also depends on what you mean about deplying SQL... YOu might wish all
of
> the clients to share data from a single database, or you might wish to
> install the MSDE version on each client, so there is no data sharing...
> In either case, at least you will have to the the SQL Connectivity piece
on
> the client.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "kim d" <kimd@.discussions.microsoft.com> wrote in message
> news:6DFA23FC-DADB-48A1-BF7B-03EF46AEE5D8@.microsoft.com...
> > Hi,
> > We're in the process of developing a .NET application which will use a
> > SQLServer database. When installed/deployed the application will query
> this
> > database. I assume each time the application is installed the SQL Server
> > database will need to be installed. Is this the case - sorry I know it's
a
> > dumb question but I am a complete SQL Server novice. If this is the case
> then
> > which licensing option should we go for?
> > Any help would be greatly appreciated.
> > -Kim
>
>