I am planning on upgrading my SQL 2005 EE to SQL 2008 EE. I have like 22 user database on my SQL 2005 Server. I would like to know what other upgrade tools are out there to check the code compatibility from SQL 2005 to SQL 2008 throughly and report of any un-known and un-seen issues? I have read a lot about upgrade advisor - and the conclusion i have reach is, upgrade advisor doesnt do that great of the job. is somebody aware of this? can you please suggest something here?
Thanks,