PASS Community Summit 2008 - Program Sessions
SQL Server Heroes


Click to preview our action-packed agenda

PASS Community Summit 2008: Program Sessions (Database Administration)



Upgrading to SQL Server 2008: Lessons learned and recommended practices

Presenter:
Joe Yong (Scalability Experts)

Session Details

How did you test your application before upgrading to SQL Server 2005 a few years back? Read the marketing glossies that said "No major changes, it just works!" so you "plonked" it in and hoped it worked? Did it? How about running Upgrade Advisor? Did you encounter problems after UA said there weren't any? Ever heard of the Upgrade Assistant tool? 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. This session will cover both tools and application compatibility testing methodology developed joint by Microsoft and Scalability Experts. Beyond just static analysis of your database, this session will also provide 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.

Register Now for PASS Community Summit 2008!