My company has a Server with Windows Server 2003, and SQL Server 2000. We are planning to migrate just the database server, a provider said us the migration would be better to 2005 first, and then to 2008, because "the SQL Server 2008 is best suited for Windows Server 2008".
Which are the pros and cons of each of these approaches?
- Migrate SQL 2000 to SQL 2005 and then to SQL 2008
- Migrate SQL 2000 directly to SQL 2008
NOTE: Changing Operating System is not an option ($$$) right now for the company.
Any article or experiences would be very much appreciated