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

Posted on 2009-04-27
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.


Question by:kflorian
    LVL 51

    Accepted Solution

    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:

    And that team blogg (including an interesting entry) :

    Author Comment

    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.  

    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.


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Use these top 10 tips to master the art of email signature design. Create an email signature design that will easily wow recipients, promote your brand and highlight your professionalism.
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now