Openfire database problem

I have install Openfire & configure the Openfire database on SQL server 2008 now I want to migrate all the database in SQL server 2008 R2 but when i m going to migrate database in SQL 2008 R2 its not given me any error but registration is not working & even I am not able to see my message archive which is I can see in database even yahoo, msn users which are configured in Openfire that user not able to send message to other msn or yahoo user and many other problem I just want to know is Openfire support SQL 2008 R2 or anything is required for that which I was forgot to do