automatic backup of BCM 2007 database to .sbb files

[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?

 

[sunorain]

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...

 

[Luther]

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?

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.

 

[sunorain]

good explanation but doesn't look like useful tip in response to a problem

 

[Remove ABCD from Email address to reply]

Okay, now that I can create a backup file, how would I restore it if I
needed to?

 

[Piotr Kierklo]

Okay, now that I can create a backup file, how would I restore it if I

needed to?

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.