Migrate BCM 2003 data to BCM 2007

M

MWM

I recently purchased Office 2007 with BCM. I have an extensive BCM database
in the 2003 version. I need to move the 2003 database into the 2007 database.
I have tried changing the database using osql from a command prompt (like the
old method for 2003) but apparently, BCM 2007 doesn't use the same SQL
connection methodology. Also, I assume that the schema is different and thus
an upgrade would be required to transfer the data.

Does anyone know of a method of moving this data over from the old BCM? (The
import function doesn't support mdf/ldf files.)
 
L

Luther

I recently purchased Office 2007 with BCM. I have an extensive BCM database
in the 2003 version. I need to move the 2003 database into the 2007 database.
I have tried changing the database using osql from a command prompt (like the
old method for 2003) but apparently, BCM 2007 doesn't use the same SQL
connection methodology. Also, I assume that the schema is different and thus
an upgrade would be required to transfer the data.

Does anyone know of a method of moving this data over from the old BCM? (The
import function doesn't support mdf/ldf files.)

What should happen:

When you run Ol/Bcm 2007 for the first time, it should present you
with the option of using an existing database, with your old database
showing up in the list of available databases. When you try to connect
BCM 2007 to an old database, it should migrate the database to the
2007 schema.

You're right that the old OSQL commands won't work. Probably because
the Sql instance name changed, and you need to use the new instance
name (mssmlbiz) to access the the 2007 instance.

If you change the database using sql directly--attach the old database
to the new instance--thne I expect BCM to migrate it the first time it
connects to it.

You can find what databases are attached by running the command here:
http://beyng.blogspot.com/2007/03/what-are-databases-on-bcm-instance.html

sqlcmd and osql have similar command line options.

I think 2007 Setup should have automatically detected old databases
and detached them from the old instance, in which case the old
database should show up when you run the create or select database
menu item in BCM.
 
M

MWM

Luther, thanks for your response. What should have happened didn't
(obviously). When Outlook was first run, BCM ran the configuration wizard but
I got the same error as what I get now when running the wizard.

When I run the contact manager configuration from the Help command in
Outlook 2007, it asks me if I want to create a new db or select an existing
database. I select an existing database. It only presents me with one option
in the combo box: MSBusinessContactManager.

When I click next, BCM indicates it's "finalizing business contact manager
for outlook configuration". It then terminates in an error:

"Business Contact Manager cannot save this item because it does not
recognize some of the properties."


Using the sqlcmd -E -S "localhost\mssmlbiz" -Q "select substring(name,1,20),
state_desc from sys.databases" command, I get the following databases:

master (online)
tempdb (online)
mode1 (online)
msdb (online)
MSBusinessContactMan (online)

I'm trying to connect to the last one but that gives me the foregoing error.
I'm concerned if I uninstall Office, all my settings will disappear. Is there
a utility somewhere that would allow migration?
 
M

MWM

The saga continues.

I detached the existing database which pointed to files in ApplicationsData
directory. I then reconnected the correct file from the location where BCM
2003 was accessing it. I then got the following error:

"Wrong database version 2.0.3606.0. Please migrate your Business Contact
Manager database."

Here's what I think happened:

1. Under BCM 2003, I had the database located on a USB drive.
2. The old original file (with no contacts) had been copied (not moved) to
the USB drive, leaving an old copy of the original 2003 db in the standard
location.
3. When BCM was first installed, it looked for the database in the standard
location and found an old copy from several years ago. It assumed that was
the copy I was using and connected to it.


I went back into the wizard (from Help) and was able to get past the database
selection screen. I selected upgrade the selected database. It began
processing the backup and failed with the error:

"Errors occurred during the backup of these files. The backup process has
stopped."

I attepmted this process twice with the exact same result. The third attempt
succeeded (for unknown reasons). The migration seemed to be successful but
Now I'm back to the same error:

"Business Contact Manager cannot save this item because it does not recognize
some of the properties."

The Business Contact Manager doesn't appear in the toolbar until I click on
it in the folders list. My contacts appear in the contact list but I can't
open any contacts because it gives me the following error:

"Could not load some objects because they are not available on this machine."

This makes BCM unuseable even though the contacts, accounts, etc. are
obviously there. Would it have something to do with the pst file? My pst is
2000-2002 version.
 
L

Luther

The saga continues.

I detached the existing database which pointed to files in ApplicationsData
directory. I then reconnected the correct file from the location where BCM
2003 was accessing it. I then got the following error:

"Wrong database version 2.0.3606.0. Please migrate your Business Contact
Manager database."

Here's what I think happened:

1. Under BCM 2003, I had the database located on a USB drive.
2. The old original file (with no contacts) had been copied (not moved) to
the USB drive, leaving an old copy of the original 2003 db in the standard
location.
3. When BCM was first installed, it looked for the database in the standard
location and found an old copy from several years ago. It assumed that was
the copy I was using and connected to it.

I went back into the wizard (from Help) and was able to get past the database
selection screen. I selected upgrade the selected database. It began
processing the backup and failed with the error:

"Errors occurred during the backup of these files. The backup process has
stopped."

I attepmted this process twice with the exact same result. The third attempt
succeeded (for unknown reasons). The migration seemed to be successful but
Now I'm back to the same error:

"Business Contact Manager cannot save this item because it does not recognize
some of the properties."

The Business Contact Manager doesn't appear in the toolbar until I click on
it in the folders list. My contacts appear in the contact list but I can't
open any contacts because it gives me the following error:

"Could not load some objects because they are not available on this machine."

This makes BCM unuseable even though the contacts, accounts, etc. are
obviously there. Would it have something to do with the pst file? My pst is
2000-2002 version.

The PST file should match the Outlook version, but in any case should
not affect BCM. BCM only access Outlook data through APIs, so if
Outlook is happy with the file, it should provide BCM with its
requests for data.

Regarding this error:
"Errors occurred during the backup of these files. The backup process
has stopped."

When users have reported that here, the issue was usually traced back
to folder permissions on Vista. The solution was to run Outlook as
Administrator, and, I'm guessing here, BCM could then change the
folder permissions and proceed. Are you running Vista? If you are on
Xp, add your login to the Administrator's group. And when you are done
fixing these problems, remove your login from that group to lessen
your login's vulnerability to the malware out there.

The "does not recognize some of the properties" and "Could not load
some objects" indicate that BCM failed to migrate the database
successfully.

My suggestion at this point is to create a new database with BCM and
exercise it; try to create an Account, Business Contact, etc. If you
don't run into the similar errors, then we'll know the the problem is
limited to your old database and not a general problem with your BCM
2007.

If BCM works with a new database, try selecting your old database
again, while running with Administrator permissions.
 
M

MWM

Thanks again for your help.

I am running as administrator on this machine and am using XP SP3. Sorry, I
should have specified that earlier.

I created a new BCM database. When I start up Outlook, I get the same error.

"Business Contact Manager cannot save this item because it does not
recognize some of the properties."

Of course, selecting the old database gives me the same problems.

When I try to add a contact, I get the same error.

"Could not load some objects because they are not available on this machine."
 
M

MWM

Luther said:
The PST file should match the Outlook version, but in any case should
not affect BCM. BCM only access Outlook data through APIs, so if
Outlook is happy with the file, it should provide BCM with its
requests for data.

Regarding this error:
"Errors occurred during the backup of these files. The backup process
has stopped."

When users have reported that here, the issue was usually traced back
to folder permissions on Vista. The solution was to run Outlook as
Administrator, and, I'm guessing here, BCM could then change the
folder permissions and proceed. Are you running Vista? If you are on
Xp, add your login to the Administrator's group. And when you are done
fixing these problems, remove your login from that group to lessen
your login's vulnerability to the malware out there.

The "does not recognize some of the properties" and "Could not load
some objects" indicate that BCM failed to migrate the database
successfully.

My suggestion at this point is to create a new database with BCM and
exercise it; try to create an Account, Business Contact, etc. If you
don't run into the similar errors, then we'll know the the problem is
limited to your old database and not a general problem with your BCM
2007.

If BCM works with a new database, try selecting your old database
again, while running with Administrator permissions.

I have done all this with the same results. Is there any other recourse to
resolve this problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top