I love the article, straight forward, etc. I've read a few upgrade articles recently because a client is upgrading from SQL 7 to SQL 2000. I've been running their database on my local server to see if there are any issues in the upgrade, and found exactly 1 (so far). It involves differeneces in SQL. They are using a lot of statements such as this:
This throws an error in SQL 2000 because, well convert changed from 7 to 2k. The statement works fine on 2000 this way:
So far I've had a hard time find information on similar problems in upgrading from 7 to 2000. If I were doing a 6.5 upgrade I would have that handy tool microsoft issues which helps find some of these kinds of problems. Too bad it doesn't work with 7.0 databases.