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" wrote:
[Quoted Text] > 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
|