Scalability Experts has just released a FREE tool to help with your upgrade to SQL Server 2005. Is is called the SQL Server Upgrade Assistant. This tool is based on the tool used by SE Consultants in the Application Compatibility Labs literally around the world to help ISVs verify application behavior with SQL Server 2005. It works in conjunction with the tool that you probably already have heard about from Microsoft called the SQL Server Upgrade Advisor. It helps you capture a workload trace from your server and plays it back against a SQL 2000 instance and a SQL 2005 instance so that you can know how your application will behave with SQL 2005. This tool has been very valuable to the ISVs in the labs and is now available for download from Scalability Experts at http://www.scalabilityexperts.com/default.asp?action=article&ID=317
Note: I am employed by Scalability Experts. I wanted to blog about this right away so that folks who read my blog can be among the first to download it.