Upgrading to Microsoft SQL Server 2008: Testing Tools, Methodology, and Best Practices
Play Upgrading to Microsoft SQL Server 2008: Testing Tools, Methodology, and Best Practices
Remember your last SQL Server upgrade? How did you test your application before upgrading to SQL Server 2005? You read the marketing glossies that said "No major changes, it just works!" so you did a detach/attached and it all worked. Or, did it? How about running Upgrade Advisor? Did you encounter problems after UA said there weren't any? Ever heard of Upgrade Assistant? Performing a major version upgrade can be a daunting task considering how many moving parts today's applications typically have. Verifying that your application will work without problems is no small feat. Issues such as TSQL compatibility, system and user function, deprecated features, security models, etc., all contribute to making your testing efforts harder. In many cases, the original developers are no longer around so you don't even know what is in the code. This session covers both tools and application compatibility testing methodology developed jointly by Microsoft and Scalability Experts. Beyond just static analysis of your database, this session also provides detailed guidance on how to test actual code execution against SQL Server 2008 including dynamic SQL for both in-place upgrade and side-by-side (migrate) methods.