Multiple users and offline usage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to setup a central SQL Express 2005 db server so 3 employees can
use a shared db. But I would also like to use BCM offline while traveling.

Does BCM support this? Can I setup a local SQL Express on my laptop then
replicate the data?

Thx
 
Hi Todd,

Thanks for the question. Yes bcm 2007 does support multi connections to a
cenral sql express (or sql server) and allows for offline usage. To handle
the offline case when connecting to a shared database, bcm will create a
"local" database that is a mirror of the shared DB. When you go "offline",
any addations, deletation, and or changes to your bcm data will happen on
your local db. Once you reconnect to the main shared database, all your
local changes will be compaired to the master list. If no conflicts are
found, that data will just be added. If there are conflicts, you will be
taken to the conflict resolution screen and asked how to resolve those
conflicts.

Hope that answers your question.

--
 
How do you go about doing this? Would it be possible for a hosting service to
have my BCM database, all users are remote and have a local copy, and connect
to it to update information?
--
Jay


Jerry Blake (MSFT) said:
Hi Todd,

Thanks for the question. Yes bcm 2007 does support multi connections to a
cenral sql express (or sql server) and allows for offline usage. To handle
the offline case when connecting to a shared database, bcm will create a
"local" database that is a mirror of the shared DB. When you go "offline",
any addations, deletation, and or changes to your bcm data will happen on
your local db. Once you reconnect to the main shared database, all your
local changes will be compaired to the master list. If no conflicts are
found, that data will just be added. If there are conflicts, you will be
taken to the conflict resolution screen and asked how to resolve those
conflicts.

Hope that answers your question.

--
--
Jerry Blake [MSFT]
Visit team blog at http://blogs.msdn.com/bcm

This posting is provided "AS IS" with no warranties, and confers no rights



Todd said:
I would like to setup a central SQL Express 2005 db server so 3 employees can
use a shared db. But I would also like to use BCM offline while traveling.

Does BCM support this? Can I setup a local SQL Express on my laptop then
replicate the data?

Thx
Click to expand...
Click to expand...
 
How do you go about doing this? Would it be possible for a hosting service to
have my BCM database, all users are remote and have a local copy, and connect
to it to update information?
--
Jay









- Show quoted text -
Click to expand...

It's technically feasible, but hosting a Sql database on the internet
is problematic. For security reasons, you'll have to use a VPN
(Virtual Private Network). If you can find an ISP that will host Sql
and a VPN, you should test that the performance is adequate for your
needs, before signing a contract.
 
Back
Top