powered by Jive Software

Migrating from 2.1.4+MySQL to 3.3.2+SQL Server

We’‘ve been running Jive Messenger 2.1.4 for a long time now, and I’‘ve finally decided to upgrade (actually, I’‘m finally giving up waiting on JM-865). We are currently running JM 2.1.4 on Linux with MySQL, but we will be migrating to Openfire 3.3.2 on Win2k3 with SQL Server 2005. We use LDAP users with global, shared groups (2.1.4 didn’'t support LDAP groups). The new setup will use LDAP for users and groups.

My question is this: is there any special voodoo that needs to happen to the jiveRoster and jiveRosterGroups tables to migrate to Openfire? I plan on simply doing a mysqldump and then copy the INSERT lines for each table into the new SQL Server tables. Anybody see any problems with that?