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 Files\Microsoft Office Communications Server 2007\Server\Support 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 contact 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.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s