For SQL Database Migration - Major items to be covered are mentioned in below blog
http://madhuottapalam1.blogspot.com/2008/06/upgrading-sql-server-from-lower-version.html
1. SQL Upgrade advisor - Try running this tool and analyze the recommendations of this tool
http://blogs.technet.com/andrew/archive/2008/03/26/sql-server-upgrade-advisor.aspx
2. Inplace Upgrade /Side by Side Upgrade
3. Test the Rollback strategy, In case upgrade fails how to mitigate it
4. SQL Server 2008 Upgrade Technical Reference Guide
More Reads
http://blogs.msdn.com/psssql/archive/2009/02/19/how-to-copy-dts-2000-packages-between-servers-and-from-sql-2000-to-sql-2005-and-sql-2008.aspx
Upgrading from 32bit to 64bit SQL Servers
SQL 2000 to 2005 migration: execution plan change issue.
SQL 2000 to SQL 2005 migration: temporary tables reuse issue.
Useful links for upgrading to SQL Server 2008
Transparent Benefits of SQL Server 2005
Checklist for upgrading to a new version of SQL Server - Very Good
Resources - Migration from SQL 2000/SQL2005 to SQL 2008
SQL Server 2008 Upgrade Technical Reference Guide
Very Good Tech-ed Talk
Microsoft SQL Server Upgrade, 2000 - 2005 - 2008: Notes and Best Practices from the Field
Happy Reading!!
June 29, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment