automatic backup of BCM 2007 database to .sbb files

  • Thread starter Thread starter Piotr Kierklo
  • Start date Start date
P

Piotr Kierklo

Hello

is there any way to automate backing up the BCM 2007 database, to
produce .sbb files?
I do it every day manually, by clicking menu Business Contact Manager ->
Dataase Tools -> Manage Database -> Backup Database

I was trying to do SQL backup, but I didn't succeed (problems with
restore, all clients had to resynchronize and I got multiple entries in
database, which was not good :( ).

Are there any ready-to-use-scripts, external (free) programs, or I am
forced into using some self made automation/scripting tools?
 
Of course it sounds trivial but presume that macro recorder like KeyText or
AutoMate could perform this task - basically they simply make mouse clicks
for you. It's dirty approach, but since Softies do not offer anything
better...
 
Hello

is there any way to automate backing up the BCM 2007 database, to
produce .sbb files?
I do it every day manually, by clicking menu Business Contact Manager ->
Dataase Tools -> Manage Database -> Backup Database

I was trying to do SQL backup, but I didn't succeed (problems with
restore, all clients had to resynchronize and I got multiple entries in
database, which was not good :( ).

Are there any ready-to-use-scripts, external (free) programs, or I am
forced into using some self made automation/scripting tools?
Click to expand...

The BCM backup is just a SQL backup copied into a zip folder with some
xml metadata. BCM does disconnect all the shared database clients
before doing backups and restores though, which may explain the
results you saw using SQL backup.
 
Okay, now that I can create a backup file, how would I restore it if I
needed to?
 
Okay, now that I can create a backup file, how would I restore it if I
needed to?
Click to expand...

There is no automation script for that:)
In fact, since this action is invoked usually once and requires your
assistance, you do it manually by:

From main menu bar select
Business Contact Manager -> Database Tools -> Manage Database

then click "Restore Database" button

then select backup .sbb file and proceed.
 
Back
Top