Moving BCM database to new PC

[SageAdvice]

I have a customer who uses BCM for Outlook 2003 on desktop runing XP. She has
just purchased a notebook running Vista Business. I have set this up,
installed her software tec, which in the case of BCM required installing BCM
despite the incompatibility warning, then an update for BCM and finally an
upgrade to make it compatibile with Vista. However, that is not the prioblem,
I think. I used Vista's Easy Transfer Wizard to extract all her data from the
eesktop, and that seems to have worked fine with the notable exception of the
BCM database which was not copied across. BCM on the notebook has a small and
empty database. I have tried to copy the BCM database files from the desktop
into the notebook's loaction, having copied and renamed the originals on the
notebook, but BCM on the notebook only recognises the notebook's files as a
possible database source regardless of the file names. I presume that each
database is PC name specific and that the notebook BCM will only access
database files created on it and named (internally) accordingly. I tried
export from the desktop which got all the contacts but not the accounts. I
tried a backup but that would not import into the notebook (wrong PC name I
guess). She is going to abandon the desktop, probably already could in fact,
so, when taht happens, if I rename the computer name on the notebook to that
of the desktop, will the notebook's BCM then recognise the files copied from
the desktop? Or, is there another way to move the database from one PC to
another

 

[Luther Blissett]

I have a customer who uses BCM for Outlook 2003 on desktop runing XP. Shehas
just purchased a notebook running Vista Business. I have set this up,
installed her software tec, which in the case of BCM required installing BCM
despite the incompatibility warning, then an update for BCM and finally an
upgrade to make it compatibile with Vista.  However, that is not the prioblem,
I think. I used Vista's Easy Transfer Wizard to extract all her data fromthe
eesktop, and that seems to have worked fine with the notable exception ofthe
BCM database which was not copied across. BCM on the notebook has a smalland
empty database. I have tried to copy the BCM database files from the desktop
into the notebook's loaction, having copied and renamed the originals on the
notebook, but BCM on the notebook only recognises the notebook's files asa
possible database source regardless of the file names. I presume that each
database is PC name specific and that the notebook BCM will only access
database files created on it and named (internally) accordingly. I tried
export from the desktop which got all the contacts but not the accounts. I
tried a backup but that would not import into the notebook (wrong PC nameI
guess). She is going to abandon the desktop, probably already could in fact,
so, when taht happens, if I rename the computer name on the notebook to that
of the desktop, will the notebook's BCM then recognise the files copied from
the desktop? Or, is there another way to move the database from one PC to
another

BCM v3 is mor ehelpful in this area, as it looks for mdf files in that
folder, attaches the ones it finds, and makes the ones that are
compatible (user has permission, same locale, etc) available to the
user.

With BCM v2 (2003) you can attach the database manually to BCM's Sql
Server instance. Then if the database is compatible, the user should
be able to select it.
http://beyng.blogspot.com/2006/03/how-to-attach-database-files-to-sql.html

Vista has an additional wrinkle with permissions, Sql Server 2005
doesn't run as root like it used, but as user Network Services, so you
have to ensure that user has permission to read and write the mdf file
you copied from the other machine.

 

[SageAdvice via OfficeKB.com]

Thanks Luther. I gave that a go but encountered several problems, not least
being setting permissions (need to use the Advanced button and then Edit and
select inherit properties) but mainly getting the owner of the database to
change. I was unsucessful at this even following the leads on beyng.blogspot.
com site.
But I did succeed in the task i the end using a much simpler route. I had
already tried exporting from the XP install but this only provided the
contacts, no accounts and no history. In playing around with various
solutions I realised I could export the accounts if I selected that folder
line before using File Export. Then I noticed that the Vista install had more
import options than the XP had for export.
Sure enough, the two versions were not the same and the Vista had an option
to collect the history. The difference being the Business Contact Managr
Update for Outlook 2003 (
http://www.microsoft.com/downloads/...42-6DC5-4922-9DFB-1C82237D6B62&displaylang=en
) had been installed on the Visat PC to allow SP4 which makes BCM 2003 Vista
compatible. With the Update installed on XP the wider range of Export options
allowed me to export the accounts, contacts and history in one , much larger,
file. I then created a new database in the Vista install (just to be safe)
and imported.

All data present and correct!

I have a customer who uses BCM for Outlook 2003 on desktop runing XP. She has
just purchased a notebook running Vista Business. I have set this up,

[quoted text clipped - 17 lines]

the desktop? Or, is there another way to move the database from one PC to
another

BCM v3 is mor ehelpful in this area, as it looks for mdf files in that
folder, attaches the ones it finds, and makes the ones that are
compatible (user has permission, same locale, etc) available to the
user.

With BCM v2 (2003) you can attach the database manually to BCM's Sql
Server instance. Then if the database is compatible, the user should
be able to select it.
http://beyng.blogspot.com/2006/03/how-to-attach-database-files-to-sql.html

Vista has an additional wrinkle with permissions, Sql Server 2005
doesn't run as root like it used, but as user Network Services, so you
have to ensure that user has permission to read and write the mdf file
you copied from the other machine.