We are about to embark on an upgrade of our 5.1 system to 7.0 (Microsoft version) and would like to hear from other people that have gone through this exercise. Especially want to know the level of 'compatibility'. Is it mainly a question of after upgrading to 7.0, you can expect your applications still to work, or is there a fair amount of tweaking that needs to happen, to make them 7.0 compliant ?
What would you say are the main things to watch out for ?
Also - am noticing that as of SP3, SQL2008 is supported. Are there major benefits from upgrading SQL2005 to SQL2008 too - especially towards related to system performance.
Thanks for your feedback,