I've been tasked with upgrading our aging 3.6 BES to a brand new server running 4.1.4 While in our organization, the BES project is relatively minor in terms of importance, it's also very visible so I would like the process to go as smooth as possible. To that end, I've done as much research as possible, as well as installing a test version to iron out any bugs that may arise. However, I still have a few questions that I need to ask.
So we're all on the same page (and I apologize if this gets long winded) I have been looking at various documents from RIM, and I feel that this
is the most relevant to my situation. My only question related to those instructions is in regards to step #4. Am I able to point the new BES installation to the old BES's MSDE database? And if I can, will this force me into using MSDE on the new BES as well or can I upgrade to SQL Server 2000?
This leads into my next few questions, please bear with me -->
1. The organization is currently hovering around 500 users, is it worthwhile to use SQL Server?
2. Is it worthwhile to upgrade to SQL Server if it's going to remain on the same server as the BES?
3. When I install the new BES, can I create a new SA, or do I have to use the same one as the current BES?
4. Can this migration/upgrade be done with no impact to the end user?
I think that's the extent of my questions for now, any and all help will be greatly appreciated, thank you!