There are several database compare tools out there. One that I've always like is SQLCompare by Red Gate.

In SQL 2000 that wouldn't have always worked, because using ALTER didn't update...