urgent advice on sharing data please?

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

Guest

We use BCM v2.00.4013.
To date we have been synching using export / import. We need to hold a
central d/b which can be viewed centrally and / updated
etc. We want to have access to the contact/account/opportunity data while we
are offline and then synchronize any changes that we may have made back into
the shared database when we come back into the office. Is this possible?

We are thinking of getting an exchange server and SBS implemented for this
very purpose. Do I understand that this is good idea or not?
I hope someone could answer this as we need to make a decision here quickly?

Thanks for any help.

Ian
 
I have this working so far with one issue. I will first go over how i got it
to work. You will need to have a SQL server to "host" the DB. Here is a breif
overviewof what i did.

1. Backup the DB on a workstation, restore it to the SQL server, setup rights.
2. On desktop PC's, change 2 reg entries to connect to the SQL DB.
hkey_local_ma\sw\ms\business solutions ecrm\
change SQLPort to 1433 and delete the contents of the SQLInstanceName
3. On laptop's, delete the default BCM DB
4. Setup replication between the SQL server and the local SQL server on the
laptops. (I used merge replication on a 5 minute interval)
5. Laptops do NOT need the reg changes and point to the DB that is
replicated witht he main DB.

On a side note, this seems to be working well so far with the 1 test laptop
that i have setup. BUT, on the laptop Outlook craps out after being open for
15 minutes or so. I;m not sure what is causing this so far, it COULD be the
replication. I will be testing on a couple of other machines later today.
Hope this helps...
 
Can you be more specific how you backed up and restored the DB? I can
back up the MSDE through the BCM interface. But how exactly did you
restore it on the SQL server and what specific rights did you setup?

Mark
 
I installed the MS SQL Client Tools on the computer that has the DB. Then
connected to the local MSDE instance and backed up the BCM DB. Then copied
the backup file to the SQL Server and restored to a blank DB. Then on the
rights, since we are deploying this company wide, i added the Domain Users
group to have access to the DB. Hope that helps...

Chris
 
Back
Top