Sync for SQL Server
A bit pricey but another interestting good tool for SQL 2000 and 2005.
Sync For SQLServer is designed for software developers or database administrators who are working with the Microsoft SQL Server database. It compares two SQL Server databases and determines the differences between them. It generates a SQL change script to convert the database architecture with its tables and relationships into the desired target database. The existing data in the target database remain completely intact.