Originally Posted by knottyrope
Why goto MSDE then back to SQL.
Doen not make sense. Just move the data base to the othe SQL BOX and do a Knife edge to new BES PRO box.
My thought is this. We are in the process of reworking our database environment (about 15 db servers) and i would just assume not have to worry about having the database managed externally by the dba team. This would throw all requirements and management into a single location. We used image based backups so I could easily roll back in the case of a failure without having to worry about have the databases backed up and or restored independently.
Likewise this database, though small and not resource intensive will have to be moved to another db server with a new name AFTER the installation occurs in which case the BES system settings will have to be modified to reflect this change (which does appear to be straightforward however).
That is my reasoning. Upon reading up on it more it seems there are others running 200 and 300+ clients on a local sql express database without any issues. We are running 15 right now and i dont forsee us hitting that upper limit anytime soon.