?
Solved

How to move MS Business Contact Manager from SBS 02 / SQL 05 to SBS 08 / SQL 08

Posted on 2009-04-27
3
Medium Priority
?
591 Views
Last Modified: 2012-05-06
Does anybody have detailed instructions (or excellent pointers) on how to go about moving a single SQL 2005 database of Business Contact Manager data to a new fresh install of SBS 2008 and SQL 2008?

I know it will run on SQL 08 because I have a local copy of BCM data running on SQL Express 08.

Thanks,

Ken
0
Comment
Question by:kflorian
2 Comments
 
LVL 51

Accepted Solution

by:
Mark Wills earned 2000 total points
ID: 24311774
Easiest would be to backup from 2005 and restore in 2008. The major problem / challenge will be getting the permissions set up again.

First port of call would be to use the database admin tool to create the backup and for the restore. You can also use that to re-establish permissions and shares.

If now using 64-bit, then there is a problem, and have seen this suggestion from the BCM team blogg:  http://sharepoint.microsoft.com/innovateon/officedeveloper/Developer%20Documents/Outlook2007BusinessContactManager.doc

And that team blogg (including an interesting entry) : http://blogs.msdn.com/bcm/pages/frequently-asked-questions-business-contact-manager-for-outlook-2007.aspx
0
 

Author Comment

by:kflorian
ID: 25491403
Update to my own post.

I was able to achieve my goal because I am also using Microsoft Accounting Professional 2009.  This application uses the same sql database as BCM.  

Procedure:
1.  Use MOA 2009's built-in backup capability to create a single file backup.

2.  Install SQL 2005 or 2008 on server per organization needs.  I am using SBS 2008 and SQL 2008 each in its own virtual machine running on VMWare server 2.0.   Both MOA 2007 and 2009 ran fine in SQL 2008.

3.  Install MOA 2009 and use its built-in restore capability to restore BCM SQL data.

4.  Connect desktop Outlook / BCM clients to SQL db per the normal BCM setup wizard.

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you looking for the options available for exporting EDB files to PST? You may be confused as they are different in different Exchange versions. Here, I will discuss some options available.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question