• Article

Step 2.5 Export User Data from Live Communications Server 2005 with SP1

Microsoft Office Communications Server 2007 and Microsoft Office Communications Server 2007 R2 will reach end of support on January 9, 2018. To stay supported, you will need to upgrade. For more information, see Resources to help you upgrade your Office 2007 servers and clients.

To preserve a copy of the latest user data on Live Communications Server 2005 with SP1, including contacts, groups, and ACEs (access control entries) for each user, use the Office Communications Server 2007 Dbimpexp.exe tool. If there are problems with the migration process, use this data to restore users on Live Communications Server 2005 with SP1 with their contacts, groups, and ACEs intact. This procedure works well when there are many users to be rolled back.

Note

The new Office Communications Server 2007 Dbimpexp.exe tool is required for this operation. Do not use the Live Communications Server 2005 with SP1 version of this tool.
The Office Communications Server 2007 User Services database (the RTC database) must be available when you perform this procedure, but users should not sign in while you are running the DBimpexp tool. To prevent users from signing in, stop rtcsrv services on both servers (the Live Communications Server service on the Live Communications Server 2005 SP1 server and the Communications Server service on the Office Communications Server 2007 server).

To export user data from Live Communications Server

  1. Log on to the appropriate server:

    • For a Standard Edition server, log on to the server that is running Live Communications Server 2005 with SP1 as a member of the Administrators group.

    • For an Enterprise pool, log on to the server that is running the Live Communications Server 2005 SP1 Back-End Database with an account that has read-only access to the database.

  2. Insert the Office Communications Server 2007 CD.

  3. Open a command window: Click Start, and then click Run. In the Open box, type cmd, and then click OK. Go to the \Support folder of the installation CD.

  4. At the command prompt, type one of the following:

    • For a Standard Edition server:

      Dbimpexp.exe /hrxmlfile:"<XML file path for the exported user data>"

    • For an Enterprise pool:

      dbimpexp.exe /hrxmlfile:"c:\SavedUserData.xml" /sqlserver:<sql server instance>

    If you want to export data for only a specific user, add the /user:Username parameter to the command line. The user name is a fully qualified SIP address.

    For example, to move a single user on a Standard Edition server:

    Dbimpexp.exe /hrxmlfile:"c:\SavedUserData.xml" /user:johna@contoso.com

    Note

    If the users are currently homed on multiple Live Communications Server 2005 with SP1 pools or servers, you must export the user data that is stored on each Enterprise pool or Standard Edition server. To do this, repeat steps 1 through 4 on each server or pool on which users are homed.