Would there be any issues for cross migration of database from SQL Server 2005 Express to SQL Server 2008 R2 for blackberry configuration database and database in general?
If the database is backup on SQL Server 2005, and then restored to SQL Server 2008, would there be any changes in the database structure/schema etc. that will cause application to break? Would the migrated database 'upgrade' itself when restored to new SQL Server 2008?
From my understanding, a possible worst case scenario is that all blackberry phone will have to be re-activated.
The following is a reply from expert-exchange.
BlackBerry Express 5.0.3 supports Microsoft SQL 2008 Express SP1 and is indeed the recommended version.
Microsoft SQL 2008 Express R2 is supported.
Please see the article below:
http://us.blackberry.com/support/software/server_express_exchange_aug_10_11.pdf
Please see the article below for details on how to migrate:
http://btsc.webapps.blackberry.com/btsc/search.do?cmd=displayKC&docType=kc&externalId=KB03112