If you've not yet tried them, go directly to http://red-gate.com and download the SQL Package. Once you use it you'll wonder how you ever synched 2 or more data structures, the data itself, DTS packages, etc.
From the Red-Gate site:
Who are the tools for?
- SQL Server database administrators (DBAs)
- DBAs and developers moving from SQL Server 2000 to SQL Server 2005
- IT professionals working in mixed 2000/2005 environments
- Developers who use SQL databases in their applications
- Website developers whose sites rely on SQL Server databases
- IT and systems administrators who need to manage SQL Server installations and backups
What do our tools do?
Our tools cover many aspects of working with Microsoft SQL Server databases and installations and make it easier and quicker to:
- Compare and synchronize your database schemas or data
- Migrate databases easily from SQL Server 2000 to SQL Server 2005
- Install and upgrade packaged databases remotely
- Backup, package and distribute your databases more efficiently
- Rescue and troubleshoot your databases
- Automate common tasks and use our functionality in your applications
- Track and analyze SQL Server object dependencies
Keith Barrows
ASPInsider