Moving BCM data

[Jeff Kerber]

I have my BCM data on my desktop and want to move it to my laptop. Best way
to do this?

TIA.

jeff

 

[Luther]

1) Backup up database on desktop, copy file to laptop, restore it on
laptop.

or

2) Export Contacts and Accounts to file on desktop, import file on
laptop.

#2 works better with bcmV2 as it exports all data and merges data on
import.

 

[Ed Marmon]

wouldnt it be lovely to experience these things that v2 apparently
provides...



Luther, when are we finally going to get v2 ??

also, Luther, are there any addons, free or pay, specifically for BCM??
Where?

 

[Luther]

Unofficially I've heard they're waiting for MSDE SP4 to get released so
they can ship with that version of MSDE on the CD.

I also heard that BCM v2 will only show up in the stores in the Office
w/Accounting product, later this year, but that they'd like to ship the
BCM v2 disks to all registered users ASAP. At that point the Office
packages that have the BCM disk will probably get the v2 disks.

Officially they haven't said anything, so make what you will of the
above.

The only BCM "add-on" I've heard of is a Contact Manager for PDAs that
works with BCM data and a sync BCM Contacts to PDA program. I don't use
a PDA so I don't any details, but URLs have been posted in this
newsgroup.

Note that because BCM stores its data in SQL Server, many SQL Server
related tools work with BCM data. For example, you can use Access to
create custom BCM reports.

 

[Ed Marmon]

thanks. are you aware if the speed of the application will improve? ive
read many things about how people are befuddled by the disk spinning and
slow response times on even a well-equipped system. slowness that
apparently doesnt happened on other MSDE-related products on the same
machine.

also, ms sql 2005 express is the successor to MSDE, right? i think i read
it was in beta 2 or something like that. so i'm wondering, why will BCM
v2 not be based on sql 2005 express instead of the older MSDE with the 2
gig limit, etc.

thanks for any insight, Luther.

 

[Jeff Kerber]

And how does one go about backing the database? And restoring it?


1) Backup up database on desktop, copy file to laptop, restore it on
laptop.

or

2) Export Contacts and Accounts to file on desktop, import file on
laptop.

#2 works better with bcmV2 as it exports all data and merges data on
import.

 

[Luther]

I've heard that BCM v2 is done and tested with the MSDE SP4 and that
MSDE SP4 is "mere" weeks away from shipping.

BCM v2 is much faster than v1 in many operations. And I don't think its
the case that MSDE performace has improved between service packs. I
think the BCM team has put more effort into optimizing their code and
design in v2.

However, performance is not only about BCM code. On some machines
performance improves tremendously when anti-virus software is turned
off because MSDE uses files extensively and various releases of
anti-virus file checkers have been inefficient (buggy). On other
machines additional memory (avoiding paging) can make a big difference.

SQL Express 2005 (AKA Yukon) has been in beta for years and its release
date is hard to determine with confidence. I expect that shipping bcmv2
with SQL Express would also require another round of BCM beta testing,
further delaying getting it into users' hands.

Yukon will ship with the next release of Microsoft programming tools,
Whidbey (Visual Studio 2005 ?). The latest beta of Whidbey/Yukon that I
installed wasn't fully baked. For example the new ADO, the layer of
software that connects applications to Yukon, behaved differently when
I rebuilt my MSDE apps with it; i.e. some features broke.

I expect Whidbey and Yukon will ship later this year, then bcm v3 can
be built on that platform, and will probably be delivered with the next
release of Outlook/Office.

 

[Ed Marmon]

I expect Whidbey and Yukon will ship later this year, then bcm v3 can
be built on that platform, and will probably be delivered with the next
release of Outlook/Office.

thanks for the detail. interesting. so the above would indicate, assuming
the general rumors or an office 2005 by late this year/ slip to early 2006,
so bcm 3 would be in about 10 months-ish...

i culled from some earlier posts that bcm2 still wont have customizable
fields/ability to add user fields... that's quite strange, if true, dont
you think, for a 2nd generation "contact manager"?

that's unsettling, i think, no?

 

[Guy Lapierre]

The BCM backup is found under the File Menu, Business Database.