Openfire Database script updrade 19 MS-Sql

/* Rename jiveUser to ofUser */

sp_rename ‘jiveUser’, ‘ofUser’;

should be

exec sp_rename ‘jiveUser’, ‘ofUser’;

After i replace all **sp_rename **entries to exec sp_rename …

the script is executed correctly.

So after running all upgrade scripts is the database up to version 20 upgraded, Openfire 3.6.0a is running well and

the old data are again accessible. (user, roters, gateway etc)

After this also gateway plugin database upgrade is automatically upgraded.

Hope it helps