I did SQL Server 2005 migration discussion last April with several engineers of Freeport Indonesia. I used white board, chalk talk style at that time. I did theÂ presentation again yesterday but in more formalized format. It was an SQL Server 2005 Technical Upgrade Workshop held by Microsoft Singapore. There were 3 sessions in that half day workshop:
- Transparent Benefits of Upgrading to SQL Server 2005
- How to Upgrade to SQL Server 2005
- Get The Most of SQL 2005 BI Tools, Benefits, and Upgrading
It’s not enough to cram the whole things in a half day, so I skipped some unimportant slides and did more live demos. Hopefully It gave better idea about the SQL Server 2005 benefits and migration process.Â Here is the presentation:
Microsoft already published a very good white paper for SQL Server 2005 upgrade and migration. It’s not only contain step by step wizard and screen shoot, but also how to design, prepare, and manage the migration process. Migration can become a risky job if we have a lot of DTS, AS, and heavy weight reporting services deployments. Also, did I mention the existing clustered environmentÂ 😉 ?Â This guide is definetely answer most of the uprgrade and migration questions. Download it, read it, and follow the migration path.