Microsoft – Backup user information for Office Communications Server

If you are un-installing the trial version of OCS 2007 and are upgrading to RTM, you can export all the user information and then import back to the RTM version using DBImpExp.exe tool.

Office Communications Server 2007 DBImpExp.exe tool is required for this operation. Do not use the LCS 2005 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 the Communications Server service on the Office Communications Server 2007 server.

The default location for the DBImpExp.exe tool is located in the <drive>:Program FilesMicrosoft Office Communications Server 2007ServerSupport folder of a server on which Office Communications Server 2007 is installed.

In order to export user information of every user hosted on the pool or server, run following command on the OCS Front End Server.

Standard Edition Server: dbimpexp.exe /hrxmlfile:”%temp%SavedUserData.xml”

Enterprise Pool: dbimpexp.exe /hrxmlfile:”%temp%SavedUserData.xml” /sqlserver:<SQL_Hostname>

Run the following command(s) to import the backed-up user information on the target server.

Standard Edition Server: dbimpexp.exe /import /hrxmlfile:”%temp%SavedUserData.xml”

Enterprise Pool: dbimpexp.exe /import /hrxmlfile:”%temp%SavedUserData.xml” /sqlserver:<SQL_Hostname>

If you just want to export and import list of one or few particular user(s):

add another parameter /user:<sip URL> to the above commands.

Dbimpexp.exe tool is case sensitive when using /user: parameter. If the text in the /user:switch does not match the case sensitivity exactly as it is stored in the database, an error occurs. The user portion of the URI must be exactly the same as the user portion of the SIP URI stored in Active Directory and the host portion of the URI must be entirely in lowercase.

SOURCE

LINK

LANGUAGE
ENGLISH