Install BCM07 WITHOUT SQL Lite at desktop?
  Home FAQ Contact Sign in
microsoft.public.outlook.bcm only
 
Advanced search
POPULAR GROUPS

more...

microsoft.public.outlook.bcm Profile…
 Up
Install BCM07 WITHOUT SQL Lite at desktop?         


Author: Rick S.
Date: Jan 2, 2008 11:51

Is it possible to install BCM without it automatically installing SQL Lite on
the desktop? Where are using a centralized SQL Server to store the info to
which the desktops will connect.

It just seems that the SQL Lite consumes a huge amount of resources on the
desktop and dramtically decreases the performance of the desktop.

Do you need SQL Lite in order for the program to work in 'offline' mode?
(As in on a laptop).
7 Comments
Re: Install BCM07 WITHOUT SQL Lite at desktop?         


Author: Luther
Date: Jan 2, 2008 13:36

On Jan 2, 11:51 am, Rick S. discussions.microsoft.com> wrote:
> Is it possible to install BCM without it automatically installing SQL Lite on
> the desktop?  Where are using a centralized SQL Server to store the info to
> which the desktops will connect.
>
> It just seems that the SQL Lite consumes a huge amount of resources on the
> desktop and dramtically decreases the performance of the desktop.
>
> Do you need SQL Lite in order for the program to work in 'offline' mode?  
> (As in on a laptop).

You need Sql Express to work in offline mode.

If you are not using offline, and you using a database hosted on
another machine, then you can uninstall Sql Express from the client,
and get the resources back.
no comments
RE: Install BCM07 WITHOUT SQL Lite at desktop?         


Author: Sat
Date: Jan 2, 2008 13:41

Hi Rick,

First, it is SQL Server Express edition which comes with BCM 2007.
Yes, Offline also uses SQL Server. If you already have SQL Server, BCM will
create its instance in the SQL Server.

-Sat

"Rick S." wrote:
> Is it possible to install BCM without it automatically installing SQL Lite on
> the desktop? Where are using a centralized SQL Server to store the info to
> which the desktops will connect.
>
> It just seems that the SQL Lite consumes a huge amount of resources on the
> desktop and dramtically decreases the performance of the desktop.
>
> Do you need SQL Lite in order for the program to work in 'offline' mode?
> (As in on a laptop).
no comments
RE: Install BCM07 WITHOUT SQL Lite at desktop?         


Author: Rick S.
Date: Jan 2, 2008 13:52

Thanks.

"Sat" wrote:
Show full article (0.73Kb)
no comments
Re: Install BCM07 WITHOUT SQL Lite at desktop?         


Author: Rick S.
Date: Jan 2, 2008 13:53

Thanks.

"Luther" wrote:
> On Jan 2, 11:51 am, Rick S. discussions.microsoft.com> wrote:
>> Is it possible to install BCM without it automatically installing SQL Lite on
>> the desktop? Where are using a centralized SQL Server to store the info to
>> which the desktops will connect.
>>
>> It just seems that the SQL Lite consumes a huge amount of resources on the
>> desktop and dramtically decreases the performance of the desktop.
>>
>> Do you need SQL Lite in order for the program to work in 'offline' mode?
>> (As in on a laptop).
>
> You need Sql Express to work in offline mode.
>
> If you are not using offline, and you using a database hosted on
> another machine, then you can uninstall Sql Express from the client,
> and get the resources back.
>
no comments
Re: Install BCM07 WITHOUT SQL Lite at desktop?         


Author: Danielhsc_BR
Date: Jul 25, 2008 10:13

Hummm..
But, I my company we have to install in more or less 50 workstation. How
install without installing SQL. Because, after install in 50 workstation, we
have to uninstall only the SQL on the 50 workstation??? It's make no sense!
And if we have to install in 1000 workstation?

The setup has some parameters to not install the SQL?

--
Daniel Henrique S. Cordeiro
Rio de Janeiro - Brazil

"Rick S." escreveu:
> Thanks.
>
> "Luther" wrote:
>
>> On Jan 2, 11:51 am, Rick S. discussions.microsoft.com> wrote:
>>> Is it possible to install BCM without it automatically installing SQL Lite on
>>> the...
Show full article (1.25Kb)
no comments
Re: Install BCM07 WITHOUT SQL Lite at desktop?         


Author: Luther
Date: Jul 28, 2008 09:08

On Jul 25, 10:13 am, Danielhsc_BR
discussions.microsoft.com> wrote:
> Hummm..
> But, I my company we have to install in more or less 50 workstation. How
> install without installing SQL. Because, after install in 50 workstation, we
> have to uninstall only the SQL on the 50 workstation??? It's make no sense!
> And if we have to install in 1000 workstation?
>
> The setup has some parameters to not install the SQL?
>
> --
> Daniel Henrique S. Cordeiro
> Rio de Janeiro - Brazil
>
> "Rick S." escreveu:
>
>
>
>> Thanks.
> ...
Show full article (1.99Kb)
no comments
Re: Install BCM07 WITHOUT SQL Lite at desktop?         


Author: Chris
Date: Jul 30, 2008 14:46

We've heard this request before. As Luther said, we're optimized for
the 5 PC, no "server" market. If you removed SQL from the clients, or
did not use Offline, when the boss's computer hosting the BCM DB is
switched off or goes home, no-one would be able to access their BCM
data. Much safer - for our target market - to leave SQL and allow
Offline.

HTH,

Chris [msft]
no comments

RELATED THREADS
SubjectArticles qty Group
SQL Profiler in SQL Server 2000microsoft.public.sqlserver.programming ·